1 Reply Latest reply on Jan 22, 2019 4:56 AM by Jim Dehner

    How can i remove the first month's change while calculating average change

    Wong  Tze Xiang

      Hi guys

       

      i have a sample table showing sales, previous months sales, abs change in sales and average change in sales for the past 6 months. My problem is that the first value in the "abs change in sales" column is always the first month's total sales, is there a way to remove/ignore this number while calculating average change in sales as it is affecting my overall average calculation. Thanks

       

      Refer to sheet 22