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

# 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

 ITEMNUMBER ITEMGROUP =Date(DATE) sum(QTY) sum(ENTEREDQTY) sum(VALUE) Stockvalue RESJLG1120515 17JLG 31-10-2007 2 24 13 0 RESJLG1120515 17JLG 31-01-2008 6 24 43 0 RESJLG1120515 17JLG 29-02-2008 23 24 162 0 RESJLG1120515 17JLG 31-03-2008 20 24 123 0 RESJLG1120515 17JLG 31-08-2008 2 24 12 0 RESJLG1120515 17JLG 31-10-2008 7 24 45 0 RESJLG1120515 17JLG 31-03-2009 6 24 39 0 RESJLG1120515 17JLG 30-04-2009 5 24 33 0 RESJLG1120515 17JLG 31-10-2011 6 24 39 0 RESJLG1120515 17JLG 31-08-2012 1 24 7 7 RESJLG1120515 17JLG 31-07-2013 23 24 150 150

Thanks!

• ###### Re: How to sum rows above last transaction!?

right now i use

if( sum(ENTEREDQTY) >= rangesum (below(sum(QTY),0,sum(Total QTY))), Sum(VALUE))

this work in a table chart but now in bar chart, if the first value in QTY is below ENTEREDQTY, If there is a rest i want the rest from next transaction