1 Reply Latest reply: Aug 8, 2013 7:22 AM by Teis Wamsler RSS

    How to sum rows above last transaction!?

      Hi i am quiet new to QW and i hope some one can help with my problem.

       

      I wanna make a bar chart containing bars over ages and value of the stock, but i only wanna show stock until Qty <= ENTEREDQTY

             

      ex.     Date 31-07-2013. QTY is lower then ENTEREDQTY here i whant to date returned in a new colum - DateFlag

                Date  31-08-2012 QTY 1+23 = 24 here i what the same.
      somehow sum rows above to compare with value in stock?

      I wanna do this in the scrip because i dont need the data if

       

       

      ITEMNUMBERITEMGROUP=Date(DATE)sum(QTY)sum(ENTEREDQTY)sum(VALUE)Stockvalue
      RESJLG112051517JLG31-10-2007224130
      RESJLG112051517JLG31-01-2008624430
      RESJLG112051517JLG29-02-200823241620
      RESJLG112051517JLG31-03-200820241230
      RESJLG112051517JLG31-08-2008224120
      RESJLG112051517JLG31-10-2008724450
      RESJLG112051517JLG31-03-2009624390
      RESJLG112051517JLG30-04-2009524330
      RESJLG112051517JLG31-10-2011624390
      RESJLG112051517JLG31-08-201212477
      RESJLG112051517JLG31-07-20132324150150

       

      Thanks!