7 Replies Latest reply: Jul 31, 2017 2:17 PM by Ugonna Okoli RSS

    How can i get average of two deviation columns

    Ipsita Mahapatra

      Hi Team,

       

      Below is the data scenarios. Could you please guide me how can i achieve this average deviation.

        

      BrandRecommendedDateActualApplicationDate
      Product 12/6/201712/17/2016
      Product 14/6/20174/1/2017
      Product 12/28/20171/10/2017
      Product 14/19/20171/25/2017
      Product 22/18/20172/19/2017
      Product 22/21/20172/21/2017
      Product 28/4/20171/19/2017
      Product 24/8/20172/1/2017
      Product 31/18/20171/24/2017
      Product 34/15/20174/26/2017
      Product 34/11/20163/8/2018
      Product 45/9/20175/10/2017
      Product 45/9/20175/10/2017
      Product 45/6/20175/11/2017
      Product 45/6/20175/11/2017

      Deviation (in days) = Avg. (Actual Application Date – Recommended Date) of each Product

       

       

      Means, Avg deviation in days of Product 1, Product 2, Product 3 and Product 4.

       

      Thanks You

      Ipsita