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