From time to time we need to convert a string (or text) into a value. If we were in Excel, we would use the Value function. Unfortunately, “Value” doesn’t work in TM1. But NUMBR does!
What NUMBR Means
This function converts a string of text that looks like a number to a numeric expression, or value.
The syntax is
where string is a value stored as a string (surprise, surprise!).
An example is NUMBR (‘10.75’) which will return the numeric value 10.75.
This function can be used in both Rules and TI processes
Another example is where we have a Month dimension that uses 1, 2, 3 etc to represent months, or a Year dimension that contains 2017, 2018, 2019 etc. These can be problematic to evaluate in rules and using this function to convert them to values prior to being evaluated using an =, < or > sign, can make this smoother.
Then you could use a rule like the following to determine if an Actual/Forecast flag should show “Actual” or “Forecast”
['Actual/Forecast'] = S:
IF( NUMBR(!Year) < DB('System Control','Current Year' , 'Value' )
,IF( NUMBR(!Year) = DB('System Control','Current Year' , 'Value' )
,IF( NUMBR(!Month) < DB('System Control','Current Month' , 'Value' )