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:

  1. 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.

  2. 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)