calculating rolling avg

[raghavsurya]

Hi All,

We have sales revenue for each month and the user like to have a comparison with rolling average of previous 3 months with the actuals. Can anybody suggest how to do this.

Actuals Rolling Avg

5000 5000

6000 5500 ((5000+6000)/2)

4000 5000 ((5000+6000+4000)/3)

8000 6000 (6000+4000+8000)/3)

Thanks and Regards,

Raghav

Regards,

Raghav

[#2]

Hi Raghav,

see QV help for rangeavg (above(Sum(x), 0, 3) as example.

Good luck!

Rainer

[raghavsurya]

Thanks Rainer

[#4 · Accepted solution]

Raghav,

here are an example.

Rainer

[raghavsurya]

thanks dude