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
34
Views
21
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 21 comments

Summary

Rolling 12 Months Calculation

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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