Calculating Rolling Average

[farru_scorpio]

Dear Experts,

I am looking for a calculation logic to evaluate rolling average based on n of days. I am having date, sales and need rolling average. I have put a simple formula in excel attachment. 

Please assist. Thank you in advance.

Farrukh

[Or]

See e.g. https://community.qlik.com/t5/QlikView-App-Dev/Moving-Averages-in-Charts/td-p/373666

Or just search this site for Rolling Average or Moving Average.