2 Replies Latest reply on Dec 2, 2016 1:20 PM by Brittney Parker

    Difference Between Two Moving Calculations

    Brittney Parker

      Hello All,

           I want to find the difference between the previous months booked orders and the average of the previous six months booked orders, but not sure on how to go about that. 


      I have created two table calculations, both on separate worksheets:

                 MovingAverage: Which is the moving average of the past six months of booked orders.

                 MovingBooked: Which is the moving MAX of the previous months booked orders.


      Attached is what I'm working with.


      Any help would be greatly appreciated!