Math

Absolute value

Returns the absolute value of a variable –> learn more

ABS(@variable)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	-

Arithmetic

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

(@expression @operator @expression_2)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	true	-
@operator	enum	any of: +, -, *, /	true	(E.g., +)
@expression_2	variable or literal	any integer, float	true	-

Ceiling

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

CEILING(@variable)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any float	true	-

Integer divide

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

DIV(@expression, @expression_2)

Return type

integer

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer	true	-
@expression_2	variable or literal	any integer	true	-

e ^ x

Compute the natural exponential of a value –> learn more

EXP(@expression)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	true	-

Floor

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

FLOOR(@variable)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any float	true	-

Greatest

Find the largest of several values –> learn more

GREATEST(@expression)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variables or literals	any integer, float, date, dateTime, time, string, boolean	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)

Return type

boolean

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	-

Is NaN

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

IS_NAN(@variable)

Return type

boolean

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	-

Least

Find the smallest of several values –> learn more

LEAST(@expression)

Return type

dynamic (input-dependent)

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variables or literals	any integer, float, date, dateTime, time, string, boolean	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])

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	true	-
@literal	literal	any integer, float	false	-

Mod

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

MOD(@expression, @expression_2)

Return type

integer

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer	true	-
@expression_2	variable or literal	any integer	true	-

Power

Raises a value to a power –> learn more

POW(@expression, @expression_2)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	true	-
@expression_2	variable or literal	any integer, float	true	-

Random

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

RAND()

Return type

float

Parameters

Round

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

ROUND(@expression[, @literal])

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	true	-
@literal	literal	any integer	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)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	true	-
@expression_2	variable or literal	any integer, float	true	-

Sign

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

SIGN(@variable)

Return type

integer

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@variable	variable	any integer, float	true	-

Sqrt

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

SQRT(@expression)

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	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])

Return type

float

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@expression	variable or literal	any integer, float	true	-
@literal	literal	any integer	false	-