====== 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|