ROUND operator
ROUND operator creates a property that implements the rounding operation.
Syntax
ROUND(numExpr[, scaleExpr])
Description
The ROUND operator creates a property whose value is the number rounded to the given precision. See the rounding operation for the result class and the rounding behavior, including how the precision determines the rounding direction.
Parameters
-
numExprExpression whose value determines the number to be rounded. The value must belong to one of the numeric built-in classes.
-
scaleExprExpression whose value determines the number of digits to which the number is rounded. The value must belong to the
INTEGERclass. If not specified, the number is rounded to the nearest integer.
Examples
number = DATA NUMERIC[10,3](); //12345.678
rounded = ROUND(number()); //12346
rounded1 = ROUND(number(), 2); //12345.68
rounded2 = ROUND(number(), -2); //12300
FORM roundTest
PROPERTIES() number, rounded, rounded1, rounded2;