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, […]
StringToNumber TM1 Process: Use and Syntax
StringToNumber allows us to convert a value, stored as text, into a number in TM1 Turbo Integrator processes. From there it can be used mathematically.
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.