Moving Average not working properly
I'm trying to create a 10 week moving average graph of our bought and used. The data is as below
The 10 week moving averages that Yellowfin is calculating are not correct.
The issues are
1. It does not allow to skip the first 9, so first 9 averages aren't based on 10 records anyway.
2. The 10th record should be an average of previous 10 records i.e.
14/08/2016, 34844.00, 25022.00
Whereas yellowfin shows it as
14/08/2016, 28177.00, 39,254.00
I have double checked things through attached excel as well, but the averages are way off actual values.
Can someone suggest what could be going wrong here?