Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Oops. brainfart Try this instead:
rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,4)) -1
Try this: rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,56)) -1
Hi,
Thanks for your reply,
I am getting some different percentages, not exactly as show in excel.
Could you please advice on this
Oops. brainfart Try this instead:
rangesum(above(Amount,0,4)) / rangesum(above(Amount,52,4)) -1