A user wants to track the total value of Sales Orders created for each Project. For example, if Project A has three Sales Orders for 150, 100, and 50, the report should show Project A with a total Sales Order amount of 300.
Create a saved search that summarizes Sales Order amounts by Project, then validate the results against the Project record and related transactions.
- Go to Reports > New Search > Project.
- On the Criteria subtab, add a filter:
- Transaction : Type is any of Sales Order
- On the Results subtab:
- Keep Name or ID to identify the Project.
- Add a currency formula field:
- Field: Formula (Currency)
- Summary Type: Sum
- Formula:
DECODE({transaction.type}, 'Sales Order', {transaction.amount}, 0) - Custom Label: Total Sales Order Amount
- Save and run the search.
This setup groups Sales Order transaction amounts by Project and displays the summed Sales Order total for each Project.