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 updated
Was this helpful?