TM1 Function for TI, StringToNumber

Converts a string into a numeric value.

What is the StringToNumber function?

StringToNumber converts a string into a numeric value.

Where can the StringToNumber function be used?


Which TM1 Server version is this function available for?

Version 11 and 12

What is the syntax for StringToNumber?


String = any string value​

Note:- The decimal separator is based on the regional options settings of Microsoft Windows.

A demonstration on how to use StringToNumber

Use StringToNumber to convert a string variable into a numeric value when exporting to a text file.