1. Calculation and Query Reference for Oracle Essbase
  2. MDX
  3. MDX Function List
  4. Round

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 or an expression that returns a numeric value (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.