
1. Re: Calculating 4 week average
Yuriy Fal Mar 6, 2016 3:44 PM (in response to Monique Turner)Hi Monique,
Hope this could help:
WINDOW_SUM( SUM([Spend]), 3, 0 ) / WINDOW_SUM( SUM([Leads]), 3, 0 )
Yours,
Yuri

2. Re: Calculating 4 week average
Monique Turner Mar 10, 2016 5:45 AM (in response to Yuriy Fal)Hi Yuriy! Thanks for your suggestion but unfortunately that formula isnt giving me the correct numbers either. It's getting the last number correct, but I need the previous weeks to be correct also.

3. Re: Calculating 4 week average
Yuriy Fal Mar 10, 2016 6:16 AM (in response to Monique Turner)Hi Monique,
What numbers are you expecting to get?
"Average of Averages"  as in columns 3 and 6?
Or "Weighted Averages"  as in columns 4 and 7?
Please find the attached wb.
Yours,
Yuri

SampleData_YF.twbx 173.5 KB


4. Re: Calculating 4 week average
Monique Turner Mar 10, 2016 6:30 AM (in response to Yuriy Fal)The "weighted averages" numbers are correct from columns 4 and 7 !
How do I do that?
Thank you so much for your help!

5. Re: Calculating 4 week average
Yuriy Fal Mar 10, 2016 6:51 AM (in response to Monique Turner)You could see that the calculations in col 4 and 7
are exactly those mentioned above in my first reply :)
yours,
yuri

6. Re: Calculating 4 week average
Monique Turner Mar 10, 2016 7:21 AM (in response to Yuriy Fal)Thank you! One more quick question though  is the calculation the same if I need it to calculate for way more rows (roughly 180 more?)

7. Re: Calculating 4 week average
Yuriy Fal Mar 10, 2016 7:24 AM (in response to Monique Turner)Yep, the calculation remains the same.

8. Re: Calculating 4 week average
Monique Turner Mar 10, 2016 8:26 AM (in response to Yuriy Fal)Thank you so much!!