Help with rangeavg function not working

[fashid]

Hi,

     I am in the process of creating 3 months rolling average and i am trying to use rangeavg function to get the rolling average

im attaching a qvw file and also the excel file for the data source.

When i apply the rangeavg function it does not work and returns me the same values. what could be the problem

[fashid]

Please Can anybody help with this

[tresesco]

Your qvw file has nothing in the front-end.

[fashid]

Oops sorry and i was wondering that maybe i was banned or something like that from the community ... well i figured it out on myself but really thank you for pointing it out or else i would have kept wondering all the time

[nizamsha]

=sum({$<[Month Year]={">=$(=Addmonths(Max([Month Year]),-3))<=$(=Max([Month Year]))"}>}Value)/4

[arjunkrishnan]

Hai Nadeem

Use This Express It Make Vry Useful For U..

=avg({$<[Month Year]={">=$(=Addmonths(Max([Month Year]),-2))<=$(=Max([Month Year]))"}>}Value)/4