Skip to Content
0
Former Member
Mar 03, 2009 at 06:25 PM

Calculating Rolling Twelve Months Usage

83 Views

Hi Everyone,

In my ODS I have monthly energy usage by customer. In my query I have to show rolling twelve month energy usage.

How do I create the CKF?

I think a normal Sum of months from Jan to Dec is not right. I have to consider the present month and calculate for the past 11 months including this month. How do I go about this.

You are your views. Your help will be greatly appreciated.

Thanks

Kumar.