% sales growth for the latest week

[#1]

Hello,

I have sales data for W1, W2,...,W8, i need to calculate % sales growth for the latest week i.e. W8/Avg (W1,W2,...W7).

Regards,

Chaithra

[Gysbert_Wassenaar]

W8/rangeavg(W1,W2,W3,W4,W5,W6,W7)

[SunilChauhan]

(     (W8-w7)/W7 )*100

if you want latest week over 2nd latest week

[#4]

Thanks Gysbert for your quick response.

I need to calculate the % sales growth.

i.e. Week8 sales/Avg(W1 sales,..... to...W7 sales)

[Gysbert_Wassenaar]

QlikCommunity Tip: How to get answers to your post?