Rounds expression to numDigits.
@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. |
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
@ABS
@INT
@TRUNCATE
@REMAINDER
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |