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