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 12 Months Calculation

Received Response
edited Sep 11, 2019 5:22AM in Oracle Analytics 21 comments


Rolling 12 Months Calculation


I need to figure out how to get a rolling 12 months on my report.  I was using MSUM function, but the numbers seem close but not quite right.  I also saw a PERIODROLLING function, i tried that, but i must not be doing something right.  Which of those two should i be using, or should i use a differernt function to figure out a ROLLING 12 Months?

my MSUM calc is:     MSUM((COUNT(*)), 11)

I highlighted in my image, the total is 695 for Nov 2018 but my database says 714.  and if i do a straight count report i get 714.


Howdy, Stranger!

Log In

To view full details, sign in.


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