Search…
⌃K

Math

Round

Return a rounded number.

Expression:

ROUND(value: float)

Return:

roundedValue: float

Example of usage:

ROUND(1.45)
Return value:
1

Floor

Returns the rounded-down number.

Expression:

FLOOR(value: float)

Return:

roundedValue: float

Example of usage:

FLOOR(1.45)
Return value:
1

Ceil

Returns the rounded-up number.

Expression:

FLOOR(value: float)

Return:

roundedValue: float

Example of usage:

CEIL(1.45)
Return value:
2

To Fixed

Returns the number added to specified decimals.

Expression:

TO_FIXED(value: float, decimals: integer)

Return:

roundedValue: float

Example of usage:

TO_FIXED(123,3)
Return value:
123.000

Min

Returns a minimal numeric value from a series.

Expression:

MIN(value: array)

Return:

minimalValue: float

Example of usage:

MIN(11, 79, 82)
Return value:
11

Max

Returns a maximal numeric value from a series.

Expression:

MAX(value: array)

Return:

maximalValue: float

Example of usage:

MAX(11, 79, 82)
Return value:
82

Format Number

Returns a formatted number with specified decimal places, delimiter, and decimal point.

Expression:

FORMAT_NUMBER(number: float, decimals: integer, delimiter: string, decimalPoint: string)

Return:

formattedNumber: string

Example of usage:

FORMAT_NUMBER(12346734.12, 4, ".", ",")
Return value:
"12.346.734,1200"
Last modified 6mo ago