I have a table of stock transactions.
Each record has a quantity, and a type:
....And a depot
....and various other fields.
I've got two summary fields:
Summary of StockIN (total of quantity of any record which is of type Stock IN)
Summary of StockOUT (total of quantity of any record which is of type Stock OUT)
I want another calc to show the "Summary of Stock IN" less "Summary of Stock OUT", so that I can show the "Summary of Stock Current", and I want to be able to show this in multiple summary parts, depending on what fields the table has been sorted by.
I can't get the summary fields to work in calculations, and I'm banging my head against the GetSummary function.
Can anyone help?