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.