@ROUND

Rounds expression to numDigits.

Syntax

@ROUND (expression,numDigits)

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

@ABS
@INT
@TRUNCATE
@REMAINDER

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com