Skip to main content

List of number functions

Number functions
Name Description
Compare numbers Compares this field to another field or a constant
Format numbers Allows to format number (decimal, integer & scientific) in a specific format or pattern
Remove fractional part Rounds towards zero. (3.74 -> 3) and (-3.74 -> -3)
Remove negative values Replaces negative integers or decimal values with an empty values.
Round value using ceil mode Rounds up value to the nearest number, depending on the precision you set. (3.14 -> 4 if Precision is set to 0, and 3.14 -> 3.2 if Precision is set to 1)
Round value using down mode Rounds towards zero. (3.74 -> 3 and -3.74 -> -3 for a Precision set to 0)
Round value using floor mode Rounds down value to the nearest number, depending on the precision you set. (3.74 -> 3 if Precision is set to 0, and 3.74 -> 3.7 if Precision is set to 1)
Round value using halfUp mode Rounds value to the closest number, depending on the precision you set. (3.14 -> 3 and 3.74 -> 4 for a Precision set to 0)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!