Math & Trigonometry
ABS
✔️ Safe to use in filter queries
Returns the absolute value of a number, a number without its sign.
Syntax
ABS(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Can be any valid expression as long as it resolves to a number. |
ACOS
✔️ Safe to use in filter queries
Returns the inverse cosine (arccosine) of a number, in radians in the range 0 to Pi.
Syntax
ACOS(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number between -1 and 1 (-1 <= value <= 1) |
ACOSH
✔️ Safe to use in filter queries
Returns the inverse hyperbolic cosine (hyperbolic arc cosine) of a value.
Syntax
ACOSH(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number equal to or greater than 1. |
ASIN
✔️ Safe to use in filter queries
Returns the inverse sine (arcsine) of a number in radians, in the range -Pi/2 to Pi/2.
Syntax
ASIN(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number between -1 and 1 (-1 <= value <= 1) |
ASINH
✔️ Safe to use in filter queries
Returns the inverse hyperbolic sine (hyperbolic arcsine) of a value.
Syntax
ASINH(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
ATAN
✔️ Safe to use in filter queries
Returns the inverse tangent (arctangent) of a value in radians, in the range -Pi/2 to Pi/2.
Syntax
ATAN(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
ATAN2
✔️ Safe to use in filter queries
Returns the inverse tangent (arctangent) in radians of the quotient of y and x.
Syntax
ATAN2(y, x)
| Name | Type | Description |
|---|---|---|
| y | mandatory | Any valid expression that resolves to a number. |
| x | mandatory | Any valid expression that resolves to a number. |
ATANH
✔️ Safe to use in filter queries
Returns the inverse hyperbolic tangent (hyperbolic arctangent) of a value in radians.
Syntax
ATANH(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number between -1 and 1 (-1 <= value <= 1) |
AVG
✔️ Safe to use in filter queries
Returns the average value of the numeric values.
Syntax
AVG(number1, number2, ...)
| Name | Type | Description |
|---|---|---|
| number1 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the average will be calculated. Can be any expression that resolves to a number. |
| number2 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the average will be calculated. Can be any expression that resolves to a number. |
CEIL
✔️ Safe to use in filter queries
Returns the smallest integer greater than or equal to the specified number.
Syntax
CEIL(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
COS
✔️ Safe to use in filter queries
Returns the cosine of a value that is measured in radians.
Syntax
COS(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
COSH
❌ Cannot be used in filter queries
Returns the hyperbolic cosine of a number.
Syntax
COSH(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
DEGREES
✔️ Safe to use in filter queries
Converts an input value measured in radians to degrees.
Syntax
DEGREES(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
EXP
✔️ Safe to use in filter queries
Raises Euler’s number (e, the base of the natural logarithm) to the specified exponent and returns the result.
Syntax
EXP(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
FACT
❌ Cannot be used in filter queries
Returns the factorial of a number, equal to 1 *2 * 3 *...* number.
Syntax
FACT(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
FLOOR
✔️ Safe to use in filter queries
Returns the largest integer less than or equal to the specified number.
Syntax
FLOOR(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
LN
✔️ Safe to use in filter queries
Calculates the natural logarithm of a number and returns the result as a decimal number.
Syntax
LN(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a non-negative number. |
LOG
✔️ Safe to use in filter queries
Calculates the log of a number in the specified base and returns the result as a double.
Syntax
LOG(number, base)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a non-negative number. |
| number | mandatory | Any valid expression that resolves to a positive number greater than 1. |
LOG10
✔️ Safe to use in filter queries
Calculates the log base 10 of a number and returns the result as a decimal number.
Syntax
LOG10(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a non-negative number. |
MAX
❌ Cannot be used in filter queries
Returns the largest value in a set of values.
Syntax
MAX(number1, number2, ...)
| Name | Type | Description |
|---|---|---|
| number1 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the maximum will be calculated. Can be any expression that resolves to a number. |
| number2 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the maximum will be calculated. Can be any expression that resolves to a number. |
MEDIAN
❌ Cannot be used in filter queries
Returns the median, or the number in the middle of the set of given numbers.
Syntax
MEDIAN(number1, number2, ...)
| Name | Type | Description |
|---|---|---|
| number1 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the median will be calculated. Can be any expression that resolves to a number. |
| number2 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the median will be calculated. Can be any expression that resolves to a number. |
MIN
❌ Cannot be used in filter queries
Returns the smallest value in a set of values.
Syntax
MIN(number1, number2, ...)
| Name | Type | Description |
|---|---|---|
| number1 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the minimum will be calculated. Can be any expression that resolves to a number. |
| number2 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the minimum will be calculated. Can be any expression that resolves to a number. |
MOD
✔️ Safe to use in filter queries
Returns the remainder after a number is divided by a divisor.
Syntax
MOD(number, divisor)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
| divisor | mandatory | Any valid expression that resolves to a non-zero number. |
PI
✔️ Safe to use in filter queries
Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
Syntax
PI()
POW
✔️ Safe to use in filter queries
Raises a number to the specified exponent and returns the result. 0 (zero) cannot be raised by a negative exponent in POW function.
Syntax
POW(number, exponent)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
| divisor | mandatory | Any valid expression that resolves to a number. |
PRODUCT
✔️ Safe to use in filter queries
Multiplies all the numbers given as arguments and returns the resulting number.
Syntax
PRODUCT(number1, number2, ...)
| Name | Type | Description |
|---|---|---|
| number1 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the multiplication will be done. Can be any expression that resolves to a number. |
| number2 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which the multiplication will be done. Can be any expression that resolves to a number. |
RADIANS
✔️ Safe to use in filter queries
Converts an input value measured in degrees to radians.
Syntax
RADIANS(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
RAND
❌ Cannot be used in filter queries
Returns a random number greater than or equal to 0 and less than 1.
Syntax
RAND()
RANDBETWEEN
❌ Cannot be used in filter queries
Returns a random number between the specified numbers. RANDBETWEEN raises an error if the input arguments are not numeric values and when number 1 is not smaller than number 2.
Syntax
RANDBETWEEN(number1, number12)
| Name | Type | Description |
|---|---|---|
| number1 | mandatory | Any valid expression that resolves to a number. It will be the smallest integer RANDBETWEEN will return. |
| number2 | mandatory | Any valid expression that resolves to a number. It will be the largest integer RANDBETWEEN will return. |
ROUND
✔️ Safe to use in filter queries
Rounds a number to a specified decimal place. If rounding mode is not provided, by default ROUND uses round half up mode.
Syntax
ROUND(number, decimalPlaces, roundingMode)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number which will be rounded. |
| decimalPlaces | mandatory | Any valid expression that resolves to either zero or a positive integer. |
| roundingMode | optional | Any valid expression that resolves to an integer between 0-8 inclusive. Defaults to 4 if unspecified. |
| Mode | Possible Values | Value |
|---|---|---|
| ROUND UP | Rounds away from zero | 0 |
| ROUND DOWN | Rounds towards zero | 1 |
| ROUND CEIL | Rounds towards Infinity | 2 |
| ROUND FLOOR | Rounds towards -Infinity | 3 |
| ROUND HALF UP | Rounds towards nearest neighbour. If equidistant, rounds away from zero. | 4 |
| ROUND HALF DOWN | Rounds towards nearest neighbour. If equidistant, rounds towards zero. | 5 |
| ROUND HALF EVEN | Rounds towards nearest neighbour. If equidistant, rounds towards even neighbour. | 6 |
| ROUND HALF CEIL | Rounds towards nearest neighbour. If equidistant, rounds towards Infinity. | 7 |
| ROUND HALF FLOOR | Rounds towards nearest neighbour. If equidistant, rounds towards -Infinity. | 8 |
ROUNDDOWN
❌ Cannot be used in filter queries
Rounds a number down, toward zero.
Syntax
ROUNDDOWN(number, decimalPlaces)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number which will be rounded down. |
| decimalPlaces | mandatory | Any valid expression that resolves to either zero or a positive integer which specifies the number of digits to which the number will be rounded down. |
ROUNDUP
❌ Cannot be used in filter queries
Rounds a number up, away from zero.
Syntax
ROUNDUP(number, decimalPlaces)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number which will be rounded up. |
| decimalPlaces | mandatory | Any valid expression that resolves to either zero or a positive integer which specifies the number of digits to which the number will be rounded up. |
SIGN
✔️ Safe to use in filter queries
Returns the sign of a number. 1 if the number is positive, zero if the number is zero, or -1 if the number is negative.
Syntax
SIGN(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
SIN
✔️ Safe to use in filter queries
Returns the sine of a value that is measured in radians.
Syntax
SIN(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
SINH
❌ Cannot be used in filter queries
Returns the hyperbolic sine of a value that is measured in radians.
Syntax
COSH(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
SQRT
✔️ Safe to use in filter queries
Calculates the square root of a positive number and returns the result as a decimal.
Syntax
SQRT(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a non-negative number. |
SUM
✔️ Safe to use in filter queries
Adds up numbers in a set of values and returns the resulting total.
Syntax
SUM(number1, number2, ...)
| Name | Type | Description |
|---|---|---|
| number1 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which will be added up. Can be any expression that resolves to a number. |
| number2 | mandatory | number1, number2,... are 1 to 100 numeric arguments for which will be added up. Can be any expression that resolves to a number. |
TAN
✔️ Safe to use in filter queries
Returns the tangent of a value that is measured in radians.
Syntax
TAN(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
TANH
❌ Cannot be used in filter queries
Returns the hyperbolic tangent of a value that is measured in radians.
Syntax
TANH(number)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number. |
TRUNC
✔️ Safe to use in filter queries
Truncates a number to a whole integer or to a specified decimal place.
Syntax
TRUNC(number, places)
| Name | Type | Description |
|---|---|---|
| number | mandatory | Any valid expression that resolves to a number which will be truncated. |
| places | optional | Any valid expression that resolves to an integer. Defaults to 0 if unspecified. If "places" resolves to a positive integer, TRUNC truncates to "places" decimal digits. For example, TRUNC(1234.56789, 2) truncates to two decimal places and returns 1234.56 If "places" resolves to a negative integer, TRUNC replaces "place" digits left of the decimal with 0. For example, TRUNC(1234.56789, -2) replaces to two digits left of the decimal with 0 and returns 1200 |