1 Reply Latest reply on Jun 7, 2018 4:45 PM by Shinichiro Murakami

    Daily Average Percentage Difference within a Group

    Stergios Mentesidis

      I try to estimate the daily average percentage difference of various products within a group.

       

      Assume I have the data table below

      Using table calculations, I was able to estimate the percentage difference of average price of a group, but not the average percentage difference of the products within a group.

       

       

      The desired result looks like this

      Group6/5/2018
      6/6/20186/7/2018
      G12.7% (2.7% / 1, it ignores p2 since value is NULL)10.12% ((2.24%+18%)/2)
      G2-0.30% ((-1.42%+0.81%)/2)-1.40% ((0.72%-3.52%)/2)