Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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!