4 Replies Latest reply: Nov 4, 2011 8:12 PM by Roberto Figueroa RSS

    Expression to compare with first value

    Roberto Figueroa



      In the example attached, I would like to add a fourth column so their value will be the current Quantity minus the Quantity value from the first Purchase for the same Product.


      For example for product A, Fx will be Qty - 10 which is the value from the first purchase:


      productID  dtPurchase  Quantity  Fx 
         A       01/01/2000       10      0 
         A       01/02/2000       9       1 
         A       01/03/2000       8       2


      I know that's very simple for you guys...hope can you help me.

      Thanks in advance.