RangeSum and Above

[MK_QSL]

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.

[MK_QSL]

any reply on this?

[#3]

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())))

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[MK_QSL]

Salute to Gysbert,

You deserve the top rank.... !!!