Rolling 3 months in Rolling 6 months

[rahulsud007]

Dear Experts,

I have an issue where I need to calculate rolling 3 months inside rolling 6 months.

I have used 'As of' table to calculate Rolling 6 months but unable to calculate Rolling 3 months in it.

For eg in the application For Aug 2016 for selection year 2016 = Sum(Rolling 6 months ie Mar to Aug) + (Rolling 3 months ie Jun to Aug) = 155449606 is the output required

ie -104417459 + -51032147.79 = 155449606.79

Similary for July = -117432596.0875 + -65438241.92 =-182870838.0075 is the output required.

Kindly help

[Anonymous]

did you check this?

Calculating rolling n-period totals, averages or other aggregations

Rolling Month

[rahulsud007]

Yes, got As of logic from here.