Commulative Sum

[#1]

Hi Guys,

Need your help again.

Please see my table below:

PO NO	ITEM NO	QTY
PO-10001	ITEM-01	10
PO-10002	ITEM-01	15
PO-10003	ITEM-02	20
PO-10004	ITEM-02	10

Output Table:

PO NO	ITEM NO	QTY	QTY Commulative
PO-10001	ITEM-01	10	10
PO-10002	ITEM-01	15	25
PO-10003	ITEM-02	20	20
PO-10004	ITEM-02	10	10

QTY Commulative is the Commulative Sum of QTY group by ITEM NO.

Thank you..

~skip~

[Anonymous · Accepted solution]

Hey Skip,

Here's one way of sorting it out using Peek() to determine when the ITEMNO value changes:

Load

          PONO,

          ITEMNO,

          QTY,

          if(peek('ITEMNO')<>ITEMNO, QTY, peek('QTY_Cumulative')+QTY) as QTY_Cumulative;

LOAD * INLINE [

    PONO, ITEMNO, QTY

    PO-10001, ITEM-01, 10

    PO-10002, ITEM-01, 15

    PO-10003, ITEM-02, 20

    PO-10004, ITEM-02, 10

];

[#3]

Hi Johannes,

Thank you very much, simply and exactly what I need.

Regards,

~skip~