Moving Average giving wrong values using last period. How to fix it

Please see attached dxp file. I am trying to create a moving average using last 3 cycles and it is giving me wrong values.

 

The moving average for Retail-Soap-Cycle 5 should be (87+10+25)/3 which is 40.6

 

Please help.

Attachments

AttachmentSize
Binary Data test_data_moving_average.dxp158.43 KB

(1) Answer

Login