Round Function
Description:
Round a number either up or down to a specified number of decimal places.
The value is rounded up (away from zero) if the digit after the last significant decimal place is 6-9 (positive values) or 6-9 (negative values).
The value is rounded down (towards zero) if the digit after the last significant decimal place is 0-4 (positive values) or 0-5 (negative values).
If the digit after the last significant decimal place is 5 the value is rounded to the nearest even number. If the last digit before the 5 is an even number it will be rounded down, if the last digit before 5 is an odd number it will be rounded up.
Returns:
Number
Parameters:
Parameter | Data Type | Description |
|---|---|---|
1 | Number | The number to be rounded. |
2 | Whole Number | The decimal precision. |
Examples:
When using functions inside a field, remember the field brackets:
{Round(VariableName)}
Expression | Result |
|---|---|
Round( 0.124, 2 ) | 0.12 |
Round( 0.125, 2 ) | 0.12 |
Round( -0.126, 2 ) | -0.13 |
Round( 0.135, 2 ) | 0.14 |
Related Content
-
Arithmetic Functions
Format:
Article,
1 min read