Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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