1 2 Previous Next 26 Replies Latest reply on Mar 21, 2017 7:05 PM by Morgan DUARTE

    Delta Price calculation

    Morgan DUARTE

      Hi there,

       

      I'm trying to calculate a Delta Price. (Difference between this year average selling price and last year average selling price, which is then multiplied by the quantity of this year)

      I'm actually have difficulties to do such calculation.

       

      To get the Average selling price (ASP) it's okay, using Total(sum[Sales]) / (Total(sum([QTY]), then have it run at "Cell" level, but then to run the difference and multiplied by quantity..I don't know how to do it.

       

      Here is attached an example.

       

      Ideally, I'd like to do a graph later on, with only the Delta Price value (Positive or negative) with a vertical axis and horizontal bars with the deviation, for each different offer.

       

      Hope you can help !

      Thank you !

        1 2 Previous Next