@ROUND

Rounds expression to numDigits.

Syntax

@ROUND (expression,numDigits)
ParameterDescription

expression

Single member specification, variable name, or other numeric expression.

numDigits

Single member specification, variable name, or other numeric expression that provides an integer value. If numDigits is 0 or a positive number, expression is rounded to the number of decimal places specified by numDigits. If numDigits is a negative value, expression is rounded to the nearest 10 to the power of the absolute value of numDigits. For example:

@ROUND 1234, -2) = 1200

The default value for numDigits is 0.

Example

The following example is based on the Sample Basic database:

SET UPDATECALC OFF;
Profit = @ROUND("Profit_%", 1);

This example produces the following report:

                          Market Product 
                   Profit_%                 Profit         
            Jan     Feb     Mar      Jan      Feb      Mar
            ===     ===     ===      ===      ===      === 
Scenario   21.37   19.09   18.46    21.4      19.1    18.5

See Also