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