Round

The MDX Round function for Essbase rounds a numeric value expression to the specified number of digits.

Syntax

Round ( numeric_value_expression, index )

Parameters

numeric_value_expression

A numeric value expression (see MDX Grammar Rules).

index

Expression yielding an integer value. numeric_value_expression is rounded to the number of digits specified by this value. The fractional part of index is ignored.

Example

Round(234.5678, 2) returns 234.57.