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
17
Views
1
Comments
edited Aug 2, 2018 2:42AM in Essbase 1 comment

Summary

Essbase Formula not working

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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