I have two content types, Product In and Product Out. Content types Product In has the title as Product Code, and a field as Model. The content type Product Out has a node reference (Product Code) to Product In, and a field as Customer Name.
I have a view, Product Inventory, with aggregation on. I have two fields:
- Total Product In (By counting Content types Product In's title)
- Total Product Out (By counting Content types Product Out's title)
How can I get the outstanding balance which I have inside my inventory?