5 Replies Latest reply on Jul 10, 2018 10:59 AM by Deepak Rai

    Seeing the % increase in item cost per Orders

    Mohammad Jahanzeb

      Hello,

       

      I am trying to figure out the % difference between an ATTR(Item Cost) for each item associated with a Order and Order Line during a continuous date that Item was ordered.

       

      For Example:

         

      Item #Order DateOrder and order lineAttr(Item Cost)
      12310/12/2017321-1$0.64
      321-2$0.64
      1/31/2018456-6$1.58
      5/7/2018789-4$2.35
      789-11$2.35

       

      So I would want to figure out how much was the % change of the cost of this item from the first transaction to the latest one for each and every Item.

      From the first transaction of the item, cost was $0.64 but the latest is now $2.35 for the same item.

       

      Any feedback on this will be helpful.