Page 1 of 1

ATTRS rule function returning invalid expression

Posted: Fri Oct 04, 2019 6:49 pm
by lynnsong986
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?

Re: ATTRS rule function returning invalid expression

Posted: Fri Oct 04, 2019 6:56 pm
by ascheevel
is ['Billing Month'] a string measure in your cube? If so, you wrote an N: level rule, try S: instead.

Re: ATTRS rule function returning invalid expression

Posted: Fri Oct 04, 2019 7:05 pm
by lynnsong986
thanks so much, exactly where I did wrong!!