Essbase @ROUND

Rounds expression to numDigits.

Syntax

@ROUND (expression,numDigits)
Parameter Description
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