TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​NumberToStringEx  

Available In



NumberToStringEx converts a numeric value into a string based on a specific numeric format string, specified decimal separator and specified thousands separator.


NumberToStringEx(Value, NumericFormatDecimalSepThousandsSep);

Value = any real number
Numeric Format = TM1 numeric format string e.g. #,0.## 
DecimalSep = Decimal separator to be used in the output
ThousandsSep = Thousands separator to be used in the output

Video Demo

Using data from the Product Scorecard cube, convert the value to three decimal places with a dot as the decimal separator and comma as the thousands separator.