Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Complex Calc Formula Not Working — 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

Complex Calc Formula Not Working

Received Response
edited Aug 2, 2018 2:42AM in Essbase 1 comment


Essbase Formula not working


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")
 IF (@ISMBR("Jan"))
   "Volume"= "Loaded Volume"->@MEMBER(@CONCATENATE("YTD", @NAME(@CURRMBR("Period"))));

Howdy, Stranger!

Log In

To view full details, sign in.


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