List of 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 – let us know how we can improve!