## Math functions

These functions can be used when analysing numeric data and numeric collections.

Function Description
`math::abs()` Returns the absolute value of a number
`math::ceil()` Rounds a number up to the next largest integer
`math::fixed()` Returns a number with the specified number of decimal places
`math::floor()` Rounds a number down to the next largest integer
`math::max()` Returns the maximum number in a set of numbers
`math::mean()` Returns the mean of a set of numbers
`math::median()` Returns the median of a set of numbers
`math::min()` Returns the minimum number in a set of numbers
`math::product()` Returns the product of a set of numbers
`math::round()` Rounds a number up or down to the nearest integer
`math::sqrt()` Returns the square root of a number
`math::sum()` Returns the total sum of a set of numbers

### math::abs

The `math::abs` function returns the absolute value of a number.

``math::abs(number) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::abs(13.746189);``
``13``

If the argument is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::abs("13.746189");``
``13``

### math::ceil

The `math::ceil` function rounds a number up to the next largest integer.

``math::ceil(number) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::ceil(13.146572);``
``14``

If the argument is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::ceil("13.146572");``
``14``

### math::fixed

The `math::fixed` function returns a number with the specified number of decimal places.

``math::fixed(number, number) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::fixed(13.146572, 2);``
``13.15``

If the argument is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::fixed("13.146572", 2);``
``13.15``

### math::floor

The `math::floor` function rounds a number down to the next largest integer.

``math::floor(number) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::floor(13.746189);``
``13``

If the argument is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::floor("13.746189");``
``13``

### math::max

The `math::max` function returns the maximum number in a set of numbers.

``math::max(number) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::max([26.164, 13.746189, 23, 16.4, 41.42]);``
``41.42``

If any value in the array is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::max(["26.164", 13.746189, '23', 16.4, "41.42"]);``
``41.42``

If the argument is not an array, then an `EMPTY` value will be returned:

``SELECT * FROM math::max("some invalid argument");``
``null``

### math::mean

The `math::mean` function returns the mean of a set of numbers.

``math::mean(array) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::mean([26.164, 13.746189, 23, 16.4, 41.42]);``
``24.1460378``

If any value in the array is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::mean(["26.164", 13.746189, '23', 16.4, "41.42"]);``
``24.1460378``

If the argument is not an array, then an `EMPTY` value will be returned:

``SELECT * FROM math::mean("some invalid argument");``
``null``

### math::median

The `math::median` function returns the median of a set of numbers.

``math::median(array) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::median([26.164, 13.746189, 23, 16.4, 41.42]);``
``23``

If any value in the array is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::median(["26.164", 13.746189, '23', 16.4, "41.42"]);``
``23``

If the argument is not an array, then an `EMPTY` value will be returned:

``SELECT * FROM math::median("some invalid argument");``
``null``

### math::min

The `math::min` function returns the minimum number in a set of numbers.

``math::min(array) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::min([26.164, 13.746189, 23, 16.4, 41.42]);``
``13.746189``

If any value in the array is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::min(["26.164", 13.746189, '23', 16.4, "41.42"]);``
``13.746189``

If the argument is not an array, then an `EMPTY` value will be returned:

``SELECT * FROM math::min("some invalid argument");``
``null``

### math::product

The `math::product` function returns the product of a set of numbers.

``math::product(array) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::product([26.164, 13.746189, 23, 16.4, 41.42]);``
``5619119.004884841504``

If any value in the array is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::product(["26.164", 13.746189, '23', 16.4, "41.42"]);``
``5619119.004884841504``

If the argument is not an array, then an `EMPTY` value will be returned:

``SELECT * FROM math::product("some invalid argument");``
``null``

### math::round

The `math::round` function rounds a number up or down to the nearest integer.

``math::round(number) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::round(13.53124);``
``14``

If the argument is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::round("13.53124");``
``14``

### math::sqrt

The `math::sqrt` function returns the square root of a number.

``math::sqrt(number) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::sqrt(15);``
``3.872983346207417``

If the argument is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::sqrt("15");``
``3.872983346207417``

### math::sum

The `math::sum` function returns the total sum of a set of numbers.

``math::sum(array) -> number``

The following example shows this function, and its output, when used in a select statement:

``SELECT * FROM math::sum([26.164, 13.746189, 23, 16.4, 41.42]);``
``120.730189``

If any value in the array is not a number, then it will be cast to a number before the function is run:

``SELECT * FROM math::sum(["26.164", 13.746189, '23', 16.4, "41.42"]);``
``120.730189``

If the argument is not an array, then an `EMPTY` value will be returned:

``SELECT * FROM math::sum("some invalid argument");``
``null``