====== 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.
===== Syntax: =====
Round(@Value, 'Number of decimal places', 'rounding type')
==== Number of decimal places ====
Default value is 0
==== rounding type ====
* 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.
==== Sample: ====
^Code ^ Result^
|Round('1.999', '2')
| 2.00|
|Round('1.3', '2')
| 1.30|
|Round('1.445')
| 1|
|Round('1.445', '2')
| 1.45|
|Round('1.445', '2', '1')
| 1.44|
|Round('1.445', '2', '2')
| 1.45|
|Round('1.455', '2', '1')
| 1.46|
|Round('1.455', '2', '2')
| 1.46|