3 Replies Latest reply on Oct 2, 2018 6:24 AM by Jim Dehner

    Rolling Averages

    Grace Herron

      Hello,

       

      I am trying to calculate a 3 month average for the dates and values in the view.

       

      I am using the formula WINDOW_AVG(([USHC Route Expense Per Stop w/o Fuel charge]), -2, 0).

       

      The problem is with the first and second values. The problem I am having with the formula is with the first and second values. The first value is the not an average but the same number as the actual. The second month value is the first and second month average and not the prior 3 months.

       

      1. is there a way to exclude the first two values in order to graphically show the 3 month average correctly?

      2. is there another formula that works better than the window_avg?

       

      Thanks for your help!!