Workflow Math Functions
In Designer Cloud, a math function performs mathematical calculations. Math functions can only be used with Number data types.
Abs
Abs(x)
: Returns the absolute value of (x). It is the distance between 0 and a number. The value is always positive.
Example
Abs(32)
returns 32.
Abs(-32)
returns 32.
Exp
Exp(x)
: Returns the constant e raised to the power of an exponent (x) (e^x).
Round
Round(x, mult)
: Returns x rounded to the nearest multiple of the number specified in mult.
Example
Round(55.34, 2)
returns a value of 56.Round(39.88, 10)
returns a value of 40.Round(41.1, 10)
returns a value of 40.Round(1.25, 0.1)
returns a value of 1.3.Round(1.227, 0.01)
returns a value of 1.23.
Rand
Rand()
: Returns a random number greater than or equal to 0 and less than 1.
Floor
Floor(x)
: Returns the largest integer less than or equal to x.
Example
Floor(4.1534)
returns 4.
Ceil
Ceil(x)
: Returns the smallest integer greater than or equal to x.
Example
Ceil(9.567)
returns 10.