Skip to main content

Math & Trigonometry

ABS

​​✔️ Safe to use in filter queries

Returns the absolute value of a number, a number without its sign.

Syntax

ABS(number)

NameTypeDescription
numbermandatoryCan 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
ymandatoryAny valid expression that resolves to a number.
xmandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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, ...)

NameTypeDescription
number1mandatorynumber1, number2,... are 1 to 100 numeric arguments for which the average will be calculated. Can be any expression that resolves to a number.
number2mandatorynumber1, 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a number.

COSH

​​❌ Cannot be used in filter queries

Returns the hyperbolic cosine of a number.

Syntax‌‌

COSH(number)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a non-negative number.
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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, ...)

NameTypeDescription
number1mandatorynumber1, number2,... are 1 to 100 numeric arguments for which the maximum will be calculated. Can be any expression that resolves to a number.
number2mandatorynumber1, 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, ...)

NameTypeDescription
number1mandatorynumber1, number2,... are 1 to 100 numeric arguments for which the median will be calculated. Can be any expression that resolves to a number.
number2mandatorynumber1, 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, ...)

NameTypeDescription
number1mandatorynumber1, number2,... are 1 to 100 numeric arguments for which the minimum will be calculated. Can be any expression that resolves to a number.
number2mandatorynumber1, 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a number.
divisormandatoryAny 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a number.
divisormandatoryAny 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, ...)

NameTypeDescription
number1mandatorynumber1, number2,... are 1 to 100 numeric arguments for which the multiplication will be done. Can be any expression that resolves to a number.
number2mandatorynumber1, 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
number1mandatoryAny valid expression that resolves to a number. It will be the smallest integer RANDBETWEEN will return.
number2mandatoryAny 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a number which will be rounded.
decimalPlacesmandatoryAny valid expression that resolves to either zero or a positive integer.
roundingModeoptionalAny valid expression that resolves to an integer between 0-8 inclusive. Defaults to 4 if unspecified.
ModePossible ValuesValue
ROUND UPRounds away from zero0
ROUND DOWNRounds towards zero1
ROUND CEILRounds towards Infinity2
ROUND FLOORRounds towards -Infinity3
ROUND HALF UPRounds towards nearest neighbour. If equidistant, rounds away from zero.4
ROUND HALF DOWNRounds towards nearest neighbour. If equidistant, rounds towards zero.5
ROUND HALF EVENRounds towards nearest neighbour. If equidistant, rounds towards even neighbour.6
ROUND HALF CEILRounds towards nearest neighbour. If equidistant, rounds towards Infinity.7
ROUND HALF FLOORRounds 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a number which will be rounded down.
decimalPlacesmandatoryAny 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a number which will be rounded up.
decimalPlacesmandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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, ...)

NameTypeDescription
number1mandatorynumber1, number2,... are 1 to 100 numeric arguments for which will be added up. Can be any expression that resolves to a number.
number2mandatorynumber1, 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny 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)

NameTypeDescription
numbermandatoryAny valid expression that resolves to a number which will be truncated.
placesoptional

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