>Dear all,
>
>In my report the stock is grouped as ItemID and Batch in which ItemID identify the Item in Stock and Batch identity the actual stock level, say If My stock of Acetone I have 1 bottle of 500 ml and 1 bottle of 100 ml.
>
>In the report of dispense, I record the Date, Quantity and BatchID whicn I consumed.
>In the report it show the history say
>

>Acetone
>    xxxxxx001   500ml
>       2-4-1990    300   Consumed
>       6-6-1992    100   Consumed
>       ---------------------------
>                   400

>
>Here I can sum up the total consumed volume, but I fail to calcualate the quantity left by OriginalQuantity-sum(ConsumedQuanttiy) at Batch group footer which the program report nonexisting of sum.prg(!)
>
>Is there anything wrong or otherwise calculate the result by another view before getting the report??
>
>Regards,
>
>
>
>Ransome

You have to use report variables. Create a variable, called Comnsumed_Qty. Set initial value to 0, value to store Consumed, reset at Batch Group and set calculation - Sum.

Then just put OriginalQty - Consumed_Qty where you need to put your Total.