Do you know how to convert a text date-time into a numeric (or full serial datetime) element in…
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 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 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.
Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement