Exploring TM1 - a Chartertech Company
Close this search box.

How to Convert a Text Date-time to a Numeric Element

Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For example, if you have an Excel file as the original source with a date time formatted from a date serial. In Excel the data displayed as, say, “2021-07-06 06:30” and is stored as 44383.2708333333. However, […]

NumberToString TM1 Function: How to Use and Syntax

NumberToString Function for use in Turbo Integrator processes in TM1 and Planning Analytics to convert numbers to text (or strings). From here you can use it with other strings or output to a text file.

NUMBR TM1 Function: Use and Syntax

NUMBR Function for use in Rules and TI Processes in TM1 and Planning Analytics to convert a string of text to a value in the same way the Value function works in an Excel formula. Fully explained with examples.