Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trailing 12-month average

mb1824Jan 29 2018 — edited Feb 13 2018

Hi,

I have calculated "TTM avg." below with Member Formula: @AVGRANGE(SKIPMISSING,"MTD", @CURRMBRRANGE("Period", LEV, 0,-11,0));

How do I modify the formula so that the calc extends across Years rather than restarting in Jul?

Or to put it another way, how do I calculate the green row in the 2nd screenshot rather than the orange row?

Oracle_TTM avg 1.JPG

Oracle_TTM avg 2.JPG

TIA

This post has been answered by mb1824 on Feb 13 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2018

Added on Jan 29 2018

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

25 comments

3,326 views