Skip to Content
0
A J
Jan 12, 2011 at 09:17 AM

Bex: I want to use Cumulated function in Query Designer

78 Views

I have PO Quantity field and GR Quantity field follow example below:

PO No.| GR Date | PO Quantity | GR Quantity

0001 1/1/2011 300 160

0001 5/1/2011 300 40

0001 7/1/2011 300 100

I want to show in query.

PO No.| GR Date | PO Quantity | GR Quantity | Cumulated GR Quantity | PO OutStanding (PO Quantity - Cumulated GR Quantity)

0001 1/1/2011 300 | 160 | 160 | 140

0001 5/1/2011 300 | 40 | 200 | 100

0001 7/1/2011 300 | 100 | 300 | 0

I want to use technic of Bex for this solution

Can you help me?

Thank you very much.

Edited by: A J on Jan 12, 2011 10:17 AM