@TRUNCATE

The @TRUNCATE calculation function for Essbase removes the fractional part of expression, returning the integer.

Syntax

@TRUNCATE (expression)

Parameters

expression

Single member specification, function, variable name, or other numeric expression, which returns a numeric value.

Example

In the following example, Total Sales is calculated by (1) taking the sum of the values for Direct Sales and Other Sales and (2) truncating the summed values.

"Total Sales" = @TRUNCATE(@SUM("Direct Sales":"Other Sales"));

This example produces the following report:

                   Colas      New York     Actual
                      Jan       Feb       Mar
                      ===       ===       ===
Direct Sales        678.557   645.874   675.299
Other Sales         411.299   389.554   423.547
Total Sales        1089      1035      1098

See Also

• @REMAINDER

• @ROUND