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

Essbase function to calc data of that month depending on the input value

edited Aug 2, 2018 2:36AM in Essbase 34 comments

Summary

Essbase function to calc data of that month depending on the input value

Content

HI

I am looking for an option to calculate member depending on the user input value in Essbase calc script. For example we have two years FY16,FY17. Depending on the user input for month (1 to 12) script should traverse that many months back and pick the value. If in our example we have FY16 Jan and user input value is 3, our calc should traverse to FY15 OCT value. I can use @Prior function, but unfortunately I can only hard code the value in the @Prior

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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