Summary field calculates or summarises the values recorded in the child module to the parent module. It takes data from multiple entities and summarizes it into one value as per user requirement. Summary Field in Zoho Projects is a collection of aggregate functions and can calculate sum, average, minimum, maximum, count, record count and unique count value of the selected module and field in the parent entity column.
Availability:
Summary field is available from Enterprise Plan onwards.
Benefits:
- Provides automated insights by pulling data from multiple records across modules.
- Calculates & updates values in real-time whenever records are added, updated or deleted.
- Avoids manual reporting and saves time.
Functions | Description |
Sum | Calculates the total of the values in the fields. |
Average | Calculates the mean value of the data in the fields. |
Min | Calculates the least/smallest value of the data in the fields. |
Max | Calculates the highest/ largest value in the fields. |
Record Count | Calculates the total of record values in the Related module. |
Unique Count | Calculates the distinct (non-repeating) values in the selected field. |
Count | Calculates the total of the selected fields in the selected module. |
Use Case: Summary Field usage to track expenses in a manufacturing project.
Problem statement: Real-time tracking of Expenses and Overspending
When running a manufacturing project on Zoho Projects, the manager sets task-level budget, creates tasks dependencies, and tracks expenses of all successor tasks using summary field.
Task level Tracking:
The summary field "Budget Spent" created in the task layout, updates the total expenses across tasks in real-time.
To reflect the remaining budget post expenses, they create a formula field “Residual Budget” in the Task layout.
Project-level Tracking:
At the project level, they create two summary field which aggregates the total of the Budget spent and the total of the remaining budget as “Total Expense” and “Leftover Budget”.
Overspend Tracking:
To avoid overspending, they create a workflow rule that triggers an email alert before the total expenses cross $100,000.
This helps the manager track the spent and the leftover budget at task and project level, along with real time alerts for overspending.
- Summary field can be added only to Project, Phases, and Task Layout. However, other default and custom modules & fields can be selected in the summary field form to summarize the values.
- A maximum of 5 summary fields can be created per module.
- Summary field cannot be edited, but should be deleted and created again to enable different combinations for summary field within allowed limit.
Create Summary Field
Users with enabled Custom field permissions can create Summary fields.
- Go to Set up> Customization > Layouts.
- Select the specific Project, Phase, or Task layout.
- In the Layout configuration page, drag and drop the Summary field from the New Fields section to add it to the layout.
- In the Summary Field form on the right, add Field name, and select values for Related Module, Field, Function and Return Type. Functions will be listed based on the selected field.
When adding summary field in the task layout for rolling up data from sub tasks, select whether to roll up the data from Whole Tree or from Direct Sub Tasks alone.
Check the Include data from current task box, to include the value of the task related to the sub task. - Enter a Hint for the field, if required and click Add to Layout.
The field will be added to the layout, and reflect data as per the Return type. The fields can be viewed in the Customization > Fields page.
View Summary Field
Created Summary fields show up on the Fields page.
- Go to Set up> Customization > Fields.
- Summary fields are listed along with the other fields. Scroll to find or search for the specific summary field from the search bar on top right side.
Delete Summary Field
- Go to Set up> Customization > Layouts.
- Select the specific Project, Phase, or Task layout.
- In the Layout configuration page, hover over the specific Summary field and click
to delete.
- Confirm your action by clicking on Remove in the dialogue box.
Deleting the summary fields on the layout page will not remove them completely. They get saved on the Fields page and need to be deleted to recreate a summary field with the same combinations. To delete the summary fields from the layout permanently:
- Go to Set Up > Customization > Fields.
- Hover over the specific summary field and click
.
- Confirm your action and select Delete.