Round
Use Round expression type to round a number to a specified decimal length or precision value in the Amount dimension target expression.
A precision value from -12 up to 12 can be specified in the Round expression.
Use parameters that follow this form: round(AMOUNT,<decimal_precision>)
In this example, the Round expression round(AMOUNT,1)
rounds to 1 decimal precision:
Amount Value If: | Result |
---|---|
10.18 | 10.2 |
10.14 | 10.1 |
10.15 | 10.2 |
In this example, the Round expression round(AMOUNT,1)
rounds to 0 decimal precision value:
Amount Value If: | Result |
---|---|
10.18 | 10 |
10.5 | 11 |
10.491 | 10 |
A Round precision value can be less than zero (for example, -2). When the round precision is less than zero, than the rounding occurs to the left of the decimal instead of the right.
For example, if you use a Round expression of -2 when the Amount is 574.194, then the results is 600. (round(574.193,-2)
.