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) |