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. StrToMbr returns zero if the string cannot be converted.

Example

StrToNum("0.9")

returns 0.9 as a numeric value expression.