Round

The Round() function accepts a value, the number of decimal places and the information about whether rounding up or down is performed and returns the rounded result.

Round(@Value, 'Number of decimal places', 'rounding type')

Default value is 0

• 1 = Mathematical or symmetrical rounding (to even rounding)
• 2 = Commercial Rounding (Standard)

The distinction between commercial and mathematical rounding is relevant if a 5 is after the position to be rounded and no further digit follows. Since the 5 is exactly in the middle, the mathematical rounding is rounded up and down. It is always rounded towards the even final digit, hence the term “to-Even Rounding”. I. e.: 1.5 to 2,2.5 to 2,3.5 to 4,4.5 to 5, etc.\\
In commercial rounding, a 5 is always rounded up.