Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
date,amount
1/1/2014,100
2/1/2014,200
4/1/2014,300
5/1/2014,400
6/1/2014,500
7/1/2014,
8/1/2014,700
9/1/2014,
10/1/2014,900
11/1/2014,1000
12/1/2014,
13/1/2014,1200
14/1/2014,1300
15/1/2014,1400
here i want calculate for rolling 5 days avg for sum(amount) ?
how to calculate it?
if i take out the 0 what will happen is it effect on result
no,not at all