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

A numeric value or an expression that returns a numeric value (see MDX Grammar Rules).

Example

Truncate(2.65) returns 2.

Truncate(-8.12) returns -8.