Running Total based on group value

[Luvsql]

I've created the following variable so that it takes the value of a group header as the startqty, then subtracts for each detail, which works great. However, if the group header is say 100 and the detail is 150, I don't want it to show -50 but rather stop when it meets the group header value. Is that possible?

whileprintingrecords;
numbervar StartQty;
numbervar sumdet := sumdet + {table.QtyOut};
StartQty - sumdet

 

[pmax9999]

Try amending the formula as follows:

whileprintingrecords;
numbervar StartQty;
numbervar sumdet := sumdet + {table.QtyOut};

If	StartQty - sumdet > 0 
Then	StartQty - sumdet
Else	0

Cheers
Pete