Skip to main content

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.