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 @movsum function help

Received Response
20
Views
4
Comments
edited Aug 2, 2018 2:36AM in Essbase 4 comments

Summary

Essbase @movsum function help

Content

We have an LTM (last twelve months) dynamic calc that is using the @movsum function. It appears to be working correctly until you hit the year 2017 where the calc is only pulling back data from 2017, it will not include data from 2016 when looking at 01/2017, 02/2017, or 03/2017.

The calculation is as follows:

@movsum(amount, 12, @children(All_Months));

All_Months is just a dimension with all months listed from 1993 forward.

The user provided a spreadsheet that had dates listed from 10/2015-03/2017. The calculation returns the correct value for all dates until you hit 2017 and it seems to ignore the 2016 data.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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