Hello,
I have this rule that gave me errors:
['BillingMonth']=N:ATTRS('SM_Projects',!SM_Projects,'BillingMonth');
BillingMonth is a string attribute in the format of "YYYY-MM". can someone please let me know what I did wrong here?
ATTRS rule function returning invalid expression
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
-
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: ATTRS rule function returning invalid expression
is ['Billing Month'] a string measure in your cube? If so, you wrote an N: level rule, try S: instead.
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: ATTRS rule function returning invalid expression
thanks so much, exactly where I did wrong!!