How do I FIX an ATTRIBUTE in a Member Formula? Mine is giving a ")" error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I FIX an ATTRIBUTE in a Member Formula? Mine is giving a ")" error

I've been working at this for a few days going back and forth between different ways to assign this attribute, and I keep coming back to this as the one I would most expect to work. However, it is giving me a missing parentheses error I cannot for the life of me resolve. Have I made another error in my syntax that I can't find?

The formula works if I comment out the FIX and ENDFIX statements.

FIX (@WITHATTR("SGA-COS", "==", "COS"))

"LTM COGS" =

@SUMRANGE("Expense"->@CURRMBR(Years)->@CURRMBR(Entity), Jan:@CURRMBR(Period)) +
@SUMRANGE("Expense"->@MEMBER(@PREVSIBLING(@CURRMBR(Years)))->@CURRMBR(Entity), Jan:Dec) -

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!