Problem with rolling week average

[#1]

Hello,

The file attached is an extract form my QV solution. The problem I am having is in column C (4 weeks rolling average) which returns a wrong value regardless of how much I change up the expression. I found this formula from these discussion threads

Moving Averages in Charts

moving average in qlikview | Qlik Community

Kindly someone help me out on what exactly is going wrong in my calculations?

Cheers

[Gysbert_Wassenaar]

Since you didn't post a qlikview document that shows what you're actually doing and the data you're using I can only suggest you try the approach described in this document: Calculating rolling n-period totals, averages or other aggregations