Truncate
The MDX Truncate function for Essbase returns the integral part of a number. The return value has the same sign as its argument.
Syntax
Truncate ( numeric_value_expression )
Parameters
- numeric_value_expression
-
Numeric value expression (see MDX Grammar Rules).
Example
Truncate(2.65)
returns 2
.
Truncate(-8.12)
returns -8
.