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

NumToStr

The MDX NumToStr() function for Essbase converts a double-precision floating-point value into a decimal string. The number is formatted according to locale-specific conventions.

Syntax

NumToStr (numeric_value_expression )

Parameters

numeric_value_expression

Numeric value expression (see MDX Grammar Rules).

Example

NumToStr(1)

returns "1.00".