I have created a metric and it does the job but I am thinking this would be an out of the box metric.

All I want is a 12 month rolling average of cost for a given item. The calculation I have used is:

=(TimePeriod(Cost,-11)
+TimePeriod(Cost,-10)
+TimePeriod(Cost,-9)
+TimePeriod(Cost,-8)
+TimePeriod(Cost,-7)
+TimePeriod(Cost,-6)
+TimePeriod(Cost,-5)
+TimePeriod(Cost,-4)
+TimePeriod(Cost,-3)
+TimePeriod(Cost,-2)
+TimePeriod(Cost,-1)
+TimePeriod(Cost,0))/12

And like I said it works but have I reinvented the wheel? Surely this is available OOTB and I am just not seeing it?

Hi @Dru Robinson,

I don't know about the average, but for the sum as long as it's always 12 months you can go to Values in the Ad Hoc Component Configuration, right click on Cost, then Value Field Settings and select Last 12 Months (LTM). This way you can at least save some time typing.

Regards

Dru,

There is not an OOTB report that will do the /12, but you can leverage the Annual Cost Metric as it will be a rolling metric then add the /12 in a custom column in a report.  =Annual Cost/12

Cheers,

Ryan

Hey Dru, 

I find the way you worked this out is the safest and most reliable formula. The only difference i have - instead of using "TimePeriod(Cost,0)" i just write Cost as Cost is current month by default