2 Replies Latest reply: Dec 18, 2012 12:00 PM by Vlad Gutkovsky RSS

    Tricky calculation using previous rows of a table

    Michael Ionkin
      IDID2SumPartsPercentNr of Parts for every ID_ID2
      12345110020Round(100*0,2)
      12345210030Round(100*0,3)
      12345310050100-(Round(100*0,2) +Round(100*0,3))
      54321120025Round(200*0,25)
      54321220075100-(Round(200*0,25))

       

      Hello everybody,

       

      go you know to accomplish such a task?

      I have a table which incl everything but not the last column (Nr of Parts for every ID_ID2). The only problem is the max(ID2) for every ID - here I need to calculate with the nr of the lower ID2 Keys...

       

      Any ideas??

       

      cheers chesterluck