The ROUND function allows us to control the rounding precision for a decimal expression. The syntax for the ROUND function is as follows:
DecimalResult := ROUND (Number [, Precision] [, Direction] )
Here, Number is rounded, Precision spells out the number of digits of decimal precision, and Direction indicates whether to round up, round down, or round to the nearest number. Some examples of Precision values are shown in the following table:
|
Precision value |
Rounding effect |
|
100 |
To a multiple of 100 |
|
1 |
To an integer format |
|
01 |
To two decimal places (the US default) |
|
0.01 |
Same as .01 |
|
.0001 |
To four decimal places |
If no Precision value is specified, the rounding default is controlled by a value set in General Ledger Setup in the Appln. Rounding Precision field on the Application tab. If no value is specified, rounding will default to two decimal places. If the precision value is, for example, .04 rather than .01, the rounding will be done to...