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

Rolling 3 month sum

Accepted answer
23
Views
6
Comments
edited Oct 2, 2019 3:53PM in Essbase 6 comments

Content

Hi There,

We have dimensions, Years, Periods (time dimension) with Quarter - Month, Account, etc. I would like to create rolling 3 month sum, for example, currently it is Oct, rolling three month sum would be Aug+Sep+Oct, so I create member RollSum under Period, then I am trying to use MovSum in the following formula as test

@MOVSUM ("Net Income",3, "Jan":"Jun");

However it comes back without any value when I retrieve from SmartView, any pointer and advice on where I did wrong? or is there better way to do this?

Thanks

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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