ROUND
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 what is being 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 as follows:
|
Precision value |
Rounding effect |
|---|---|
|
|
To a multiple of |
|
|
To an integer format |
|
|
To two decimal places (the US default) |
|
|
Same as for |
|
|
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...
