Average 3 months data
For your assistance please. I want to get the average of the past 3 months, however, the average result should be post to the remaining months. In the screenshot below, I created three lines items:
Commission % - input data
Latest 3 Months Average (Comm%) - I used this formula MOVINGSUM(Commission %, -2, 0, AVERAGE)
Previous 3 Months Average (Comm%) - please see formula in the screenshot.
How can I post the 5% (average of Jan, Feb, Mar) for the month of April to Dec onwards?
Thank you 🙂