Skip to main content
Version: 5.x

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 a number rounded to a specified precision. The precision can be set to a negative value, which results in rounding the least significant digits in the integer part of the number.

Parameters​

  • numExpr

    Expression whose value determines the number to be rounded. The value must belong to one of the numerical classes.

  • scaleExpr

    Expression whose value determines the number of digits to which the number is rounded. The value of the expression must belong to the INTEGER class. A positive value indicates the number of digits after the decimal point, a negative value indicates the number of digits before the decimal point, and zero indicates rounding to the nearest integer. If not specified, it defaults to zero.

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;