Complex Calc Formula Not Working
Summary
Essbase Formula not workingContent
I have a formula in a calc script that is not working if its embedded in a Fix and If statement. Hoping someone can provide some insight.
The code as is will set Volume to #MISSING. If I change the formula to hardcode it to "YTDJan" it works as I expect. If I use the same formula outside of the Fix/If statements it works so I don't think the syntax in the formula is the issue.
Thanks in Advance!
Code Snippet
FIX(@RSIBLINGS(&FFY), "Jan":"Dec") "New"( IF (@ISMBR("Jan")) "Volume"= "Loaded Volume"->@MEMBER(@CONCATENATE("YTD", @NAME(@CURRMBR("Period")))); ENDIF ) ENDFIX
0