Returns the next lowest integer value of expression.
Syntax
@INT (expression)
Parameter | Description |
---|---|
expression | Member specification or mathematical expression that generates a numeric value. |
Example
The following example is based on the Sample Basic database. Assume that the Profit % member is not tagged as Dynamic Calc.
The following formula rounds the values for West down to the nearest integer.
West=@INT(@SUM(@CHILDREN(West)));
This example produces the following report:
Profit % Cola Actual Jan Feb Mar === === === California 38.64 37.98 38.37 Oregon 17.50 16.13 16.11 Washington 29.23 30.90 32.00 Utah 23.08 23.08 20.97 Nevada -3.95 -6.76 -5.33 West 104 101 102
See Also