# 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 |