ROUND Function (Decimal)
Rounds the value of a numeric variable.
NewNumber := ROUND(Number [, Precision] [, Direction])
Parameters
- Number
Type: Decimal The number that you want to round.
- Precision
Type: Decimal This optional parameter determines the precision used when rounding. If you do not specify a Precision parameter, then the following steps are used to specify the precision:The function ReadRounding in Codeunit 1, Application Management, is called. ReadRounding returns a decimal value that is the precision. By default, the ReadRounding function returns the Amount Rounding Precision field from the GLSetup table.
If you have customized Codeunit 1 and it does not implement the ReadRounding function, then the precision is specified as 2 digits after the decimal.
- Direction
Type: Text or Code This optional parameter specifies how to round the Number parameter. The default rounding method is '='. The following are the options for rounding:'=' rounds up or down to the nearest value (default). Values of 5 or greater are rounded up. Values less than 5 are rounded down.
'>' rounds up
'<' rounds down
Property Value/Return Value
Type: Decimal
The rounded result.
Example
This example shows how to use the ROUND function. This example requires that you create the following variables and text constant in the C/AL Globals window.
| Variable name | DataType |
|---|---|
DecimalToRound |
Decimal |
Direction |
Text |
Precision |
Decimal |
Result |
Decimal |
| Text Constant | ENU Value |
|---|---|
Text000 |
ROUND(%1, %2, %3) returns %4. |
DecimalToRound := 1234.56789;
Direction := '>';
Precision := 0.001;
Result := ROUND(DecimalToRound, Precision, Direction);
MESSAGE(Text000, Format(DecimalToRound,0,1), Precision, Direction, Result);
On a computer that has the regional format set to English (United States), the message window displays the following:
ROUND(1234.56789, 0.001, >) returns 1,234.568
The following table displays some additional ROUND examples.
| Number | Precision | Direction | Rounded number |
|---|---|---|---|
1234.56789 |
100 |
= |
1200 |
1234.56789 |
0.1 |
= |
1234.6 |
1234.56789 |
0.001 |
= |
1234.568 |
1234.56789 |
0.001 |
< |
1234.567 |
1234.56789 |
0.001 |
> |
1234.568 |
-1234.56789 |
100 |
= |
-1200 |
-1234.56789 |
0.1 |
= |
-1234.6 |
-1234.56789 |
0.001 |
= |
-1234.568 |
-1234.56789 |
0.001 |
< |
-1234.567 |
-1234.56789 |
0.001 |
> |
-1234.568 |
When you round down ('<') a negative number, such as -1234.56789, it is rounded down to -1234.567. However, -1234.567 is a mathematically greater value than -1234.56789.
When you round up ('>') a negative number, such as -1234.56789, it is rounded up to -1234.568. However, -1234.568 is a mathematically smaller value than -1234.56789.
See Also
Reference
ABS Function (Decimal, Integer, BigInteger)
POWER Function (Decimal, Integer, BigInteger)
RANDOM Function (Integer)
RANDOMIZE Function (Integer)