Math
Absolute value
Returns the absolute value of a variable –> learn more
Return type
dynamic (input-dependent)
Parameters
Arithmetic
Compute simple arithmetic (+, -, *, /) –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | - | ||
| any of: | true | (E.g., +) | |
| true | - |
Ceiling
Returns the smallest integral value that is not less than the provided value –> learn more
Return type
float
Parameters
Integer divide
Divide two integer values, rounding down any remainder –> learn more
Return type
integer
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| any integer | true | - | |
| any integer | true | - |
e ^ x
Compute the natural exponential of a value –> learn more
Return type
float
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | - |
Floor
Returns the largest integral value that is not greater than the provided value –> learn more
Return type
float
Parameters
Greatest
Find the largest of several values –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | - |
Is infinity
Return true if the value is positive or negative infinity, false otherwise. Returns NULL for NULL inputs –> learn more
Return type
boolean
Parameters
Is NaN
Determines whether input value is not a number (NaN) –> learn more
Return type
boolean
Parameters
Least
Find the smallest of several values –> learn more
Return type
dynamic (input-dependent)
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| 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
Return type
float
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | - | ||
| false | - |
Mod
Modulo: compute the remainder of the division of two integers –> learn more
Return type
integer
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| any integer | true | - | |
| any integer | true | - |
Power
Raises a value to a power –> learn more
Return type
float
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | - | ||
| true | - |
Random
Generate a pseudo-random float between [0, 1) –> learn more
Return type
float
Parameters
Round
Rounds a value to the nearest integer (or, if specified, to the provided number of decimal places) –> learn more
Return type
float
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | - | ||
| 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
Return type
float
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| true | - | ||
| true | - |
Sign
Returns the sign (-1, 0, +1) of a numeric variable –> learn more
Return type
integer
Parameters
Sqrt
Compute the square root of a value; generates an error if the variable is less than 0 –> learn more
Return type
float
Parameters
Name | Type | Allowed values | Required | Placeholder (in UI) |
---|---|---|---|---|
| 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
Return type
float
Parameters
Last updated