Truncate

Returns the integral part of a number. The return value has the same sign as its argument.

Syntax

Truncate ( numeric_value_expression )
ParameterDescription

numeric_value_expression

Numeric value expression (see MDX Grammar Rules).

Example

Truncate(2.65) returns 2.

Truncate(-8.12) returns -8.