Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below table....
PartNumber | Initial Stock | OrderQty |
A | 200 | 100 |
A | 200 | 20 |
A | 200 | 50 |
A | 200 | 20 |
B | 300 | 100 |
B | 300 | 80 |
B | 300 | 20 |
B | 300 | 40 |
B | 300 | 60 |
C | 250 | 100 |
C | 250 | 50 |
C | 250 | 50 |
C | 250 | 10 |
and need result like this...
PartNumber | Initial Stock | OrderQty | Stock Left |
A | 200 | 100 | 100 |
A | 200 | 20 | 80 |
A | 200 | 50 | 30 |
A | 200 | 20 | 10 |
B | 300 | 100 | 200 |
B | 300 | 80 | 120 |
B | 300 | 20 | 100 |
B | 300 | 40 | 60 |
B | 300 | 60 | 0 |
C | 250 | 100 | 150 |
C | 250 | 50 | 100 |
C | 250 | 50 | 50 |
C | 250 | 10 | 40 |
Let me know asap.
UPDATE: Forgot to mention... I need this in UI or chart side... Inside script I can do.
any reply on this?
Hi Manish,
Have a look! do you want something like this!
Vinay
update:
Please use below in expression...
IF(PartNumber<>Above(PartNumber),[Initial
Stock]-OrderQty,[Initial Stock]-RangeSum(Above(SUM(OrderQty),0,RowNo())))
See attached qvw.
Salute to Gysbert,
You deserve the top rank.... !!!