StrToNum

The MDX StrToNum() function for Essbase converts a string to a number.

Syntax

{{StrToNum (string)}}

Parameters

string

Input string.

Notes

StrToNum returns a numeric value after converting the string to a number. For example, string "0.9" becomes the number 0.9. StrToNum returns Missing if the string cannot be converted.

Example

StrToNum("0.9")

returns 0.9 as a numeric value expression.