TM1 Function for TI, NumberToStringEx

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

What is the NumberToStringEx function?

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

Where can the NumberToStringEx function be used?

TurboIntegrator

What is the syntax for NumberToStringEx?

NumberToStringEx(Value,Ā NumericFormat,Ā DecimalSep,Ā ThousandsSep);ā€‹

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

A demonstration on how to use NumberToStringEx

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.