Weekly rolling averages

[#1]

Hello Gurus,

Would apprecaite your help on calculating weekly rolling average in QV , exactly  as shown in the excel attachment.

Tried with the rangeavg function, but no success.

Need your assitance.

Nassar

[Gysbert_Wassenaar]

Try this: rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,56)) -1

[#3]

Hi,

Thanks for your reply,

I am getting some different percentages, not exactly as show in excel.

Could you please advice on this

[Gysbert_Wassenaar · Accepted solution]

Oops. brainfart Try this instead:

rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,4)) -1