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!

Rolling 12 Months of Actuals

Jdc3798Apr 5 2018 — edited Apr 5 2018

Good Morning. I am working on a member formula to calculate last 12 months of actuals as a sum. I would prefer to set subvars to handle this calc so that I do not need to manually update all 12 months in the calc. I have created a dynamically calc'd Scenario "12_Month_Rolling" to house this member formula. So far, here is what I have. The subvars are set as follows;

&CurrActYr - FY18

&PriorActYr - FY17

&Roll12FirstMo - Apr

&LastActMo - Mar

So essentially, I want a total at every account for the sum of data from Apr 2017 to Mar 2018.

Any assistance would be greatly appreciated.

FIX ( &CurrActYr , @RELATIVE("ACC_OPEX_wo_Fringe",0) , "Final" , "GAAP_Reported" , @RELATIVE("Department",0), "CO_20" , "No_LOB" , "No_Region" , "No_Project")

(
IF (@ISMBR(&CurrMonth))

"12_month_rolling" = @SUMRANGE( "Actual" , @XRANGE ( &PriorActYr->&Roll12FirstMo , &CurrActYr->&LastActMo ) )

ENDIF
)
ENDFIX

This post has been answered by Jdc3798 on Apr 5 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2018

Added on Apr 5 2018

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

2 comments

1,007 views