@INT
The @INT calculation function for Essbase returns the next lowest integer value of an expression.
Syntax
@INT (expression)
Parameters
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