TM1 Forum

Hello, I'm getting syntax error with this rule:
['Month Factor']=N:IF(NUMBER(SUBST(!Submetering Projected Months,1,2))<5,0,1);
dimension 'Submetering Projected Months' has string elements such as:
01/1/2019
02/1/2019
03/1/2019
04/1/2019

the Subst extracts first two characters of these strings and I need to convert it to a number. i.e. "01" will be converted to 1.

can someone please let me know what is wrong with this rule?

thanks!

NUMBER() is not a TM1 function - you can try NUMBR (without the 'E') instead.

thanks so much!