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
Skip to content
  • 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!