I have some doubts. Below is my requirement
Custom Objects: Order and Line Item Requirement: Create a report Fields to be displayed in the report Order Name , Client Name, Type, Price, Total Volume , Volume received, Volume Remaining I can get the Order Name, Client Name,Type,Price,Total Volume from the Order object.
Volume received is the count of all line items with status from new to delivery(Status is from line item object) - How i do i get the count of child records based on status? since the relationship is lookup i cannot go for rollup summary. second thing, Is the custom summary formula row count satisfies this? Can i achieve this using custom summary formula or custom formula field?
Volume Remaining = Total Volume - Volume Received. If volume received is a custom summary formula , then how do i refer the formula here for this requirement?
Please help me if i am missing anything or what i am doing is wrong.