# Math

### Absolute value

Returns the absolute value of a variable –> learn more

``ABS(@variable)``

#### Return type

dynamic (input-dependent)

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@variable`

true

-

### Arithmetic

Compute simple arithmetic (+, -, *, /) –> learn more

``(@expression @operator @expression_2)``

#### Return type

dynamic (input-dependent)

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@operator`

any of: `+`, `-`, `*`, `/`

true

(E.g., +)

`@expression_2`

true

-

### Ceiling

Returns the smallest integral value that is not less than the provided value –> learn more

``CEILING(@variable)``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@variable`

any float

true

-

### Integer divide

Divide two integer values, rounding down any remainder –> learn more

``DIV(@expression, @expression_2)``

integer

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@expression_2`

true

-

### e ^ x

Compute the natural exponential of a value –> learn more

``EXP(@expression)``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

### Floor

Returns the largest integral value that is not greater than the provided value –> learn more

``FLOOR(@variable)``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@variable`

any float

true

-

### Greatest

Find the largest of several values –> learn more

``GREATEST(@expression)``

#### Return type

dynamic (input-dependent)

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

### Is infinity

Return true if the value is positive or negative infinity, false otherwise. Returns NULL for NULL inputs –> learn more

``IS_INF(@variable)``

boolean

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@variable`

true

-

### Is NaN

Determines whether input value is not a number (NaN) –> learn more

``IS_NAN(@variable)``

boolean

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@variable`

true

-

### Least

Find the smallest of several values –> learn more

``LEAST(@expression)``

#### Return type

dynamic (input-dependent)

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

### Log

Compute the logarithm of a value to a provided base; generates an error if the variable is <= 0. If no base is provided, defaults to natural log –> learn more

``LOG(@expression[, @literal])``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@literal`

false

-

### Mod

Modulo: compute the remainder of the division of two integers –> learn more

``MOD(@expression, @expression_2)``

integer

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@expression_2`

true

-

### Power

Raises a value to a power –> learn more

``POW(@expression, @expression_2)``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@expression_2`

true

-

### Random

Generate a pseudo-random float between [0, 1) –> learn more

``RAND()``

float

### Round

Rounds a value to the nearest integer (or, if specified, to the provided number of decimal places) –> learn more

``ROUND(@expression[, @literal])``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@literal`

false

-

### Safe divide

Equivalent to the divisor operator, but returns null if an error occurs, such as a division by zero error –> learn more

``SAFE_DIVIDE(@expression, @expression_2)``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@expression_2`

true

-

### Sign

Returns the sign (-1, 0, +1) of a numeric variable –> learn more

``SIGN(@variable)``

integer

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@variable`

true

-

### Sqrt

Compute the square root of a value; generates an error if the variable is less than 0 –> learn more

``SQRT(@expression)``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

### Truncate

Similar to round, but rounds to the nearest integer whose absolute value is not greater than the absolute value of the provided variable (always rounds towards zero) –> learn more

``TRUNC(@expression[, @literal])``

float

#### Parameters

NameTypeAllowed valuesRequiredPlaceholder (in UI)

`@expression`

true

-

`@literal`

false

-

Last updated