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 function synax error
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- gtonkin
- MVP
- Posts: 1198
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: NUMBER function synax error
NUMBER() is not a TM1 function - you can try NUMBR (without the 'E') instead.
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: NUMBER function synax error
thanks so much!