Rolling Sum with a Month Prompt

[Former Member]

HI GUys,

I have a requirement where  I need Rolling sum for 12 months. It should always take 12 months irrespective of the year.

So I created three variables:-

First for Denominator =RunningSum([Total Readings];([Machine]))+RunningSum(Previous([Total Readings];11);([Machine]))

Second for Numerator = =RunningSum([Good Readings];([Machine]))+RunningSum(Previous([Good Readings];11);([Machine]))

Third and Final =[Numerator]*100/[Denominator]

The result comes fine but here is the glitch. User wants to see rolling average against Current month only so I created a Prompt for Month so when WEBI is refreshed they can enter Month Value and run the webi. But it does not take previous 11 months in to consideration.

How can I achieve that if user enters Month as February for year 2014 The Rolling sum should  take All values from March 2013 till February 2014 into calculation.

Please help.

Regards

AS

[jyothirmayee_s]

Hi,

Below link might shed some light on the formula.

http://blog.davidg.com.au/2011/04/moving-average-in-webi.html

Thanks,

Jothi

[Former Member]

I followed that one..but problem is the Prompt. I don't know how to avoid Month prompt in calculation.