Summary fields in a Portal
I have a purchase order layout with a Portal showing 'Category' 'Description' 'Quantity Purchased' 'Unit Price' ' Total Price' and 'Units Used' Where I enter line items off the purchase order.
The Description is selected from a 'Conditional List' from the 'Category' field. i.e. Category 'Timber' Description '4x2', '4x4', etc.
I show all this on a report with two sub summaries for 'Category' and 'Description. I have deleted the 'Body' part and in the second sub summary (Description) part I have Summary fields for 'Quantity Purchased' and 'Quantity Used' These perform perfectly showing the correct totals.
I also have an 'In Hand' field in the description sub summary which is a 'Calculation' field
'SumSummaryPurchased' - 'SumSummaryUsed'
This however shows a Total which encompasses all the categories and descriptions together, albeit a correct figure.
What I am trying to achieve is a quantity in hand for each description.
Any help would be appreciated.