Summary Field

Summary Field

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:
  1. Provides automated insights by pulling data from multiple records across modules.
  2. Calculates & updates values in real-time whenever records are added, updated or deleted.
  3. 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.

Idea
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.

  1. 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.
  2. A maximum of 5 summary fields can be created per module.
  3. 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.
  1. Go to Set up> Customization > Layouts.
  2. Select the specific Project, Phase, or Task layout.
  3. In the Layout configuration page, drag and drop the Summary field from the New Fields section to add it to the layout.
  4. In the Summary Field form on the right, add Field name, and select values for Related ModuleFieldFunction 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.
  5. 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. 
  1. Go to Set up> Customization > Fields. 
  2. 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

  1. Go to Set up> Customization > Layouts.
  2. Select the specific Project, Phase, or Task layout.
  3. In the Layout configuration page, hover over the specific Summary field and click  to delete.
  4. 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:
  1. Go to Set Up > Customization > Fields.
  2. Hover over the specific summary field and click .
  3. Confirm your action and select Delete.


        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          Access your files securely from anywhere

            Zoho CRM Training Programs

            Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

            Zoho CRM Training
              Redefine the way you work
              with Zoho Workplace

                Zoho DataPrep Personalized Demo

                If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

                Zoho CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                    All-in-one knowledge management and training platform for your employees and customers.

                                              Create. Review. Publish.

                                              Write, edit, collaborate on, and publish documents to different content management platforms.

                                              Get Started Now




                                                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                    Manage your brands on social media


                                                                      • Desk Community Learning Series


                                                                      • Digest


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Glossary


                                                                      • Desk Marketplace


                                                                      • MVP Corner


                                                                      • Word of the Day


                                                                      • Ask the Experts


                                                                        Zoho Sheet Resources

                                                                         

                                                                            Zoho Forms Resources


                                                                              Secure your business
                                                                              communication with Zoho Mail


                                                                              Mail on the move with
                                                                              Zoho Mail mobile application

                                                                                Stay on top of your schedule
                                                                                at all times


                                                                                Carry your calendar with you
                                                                                Anytime, anywhere




                                                                                      Zoho Sign Resources

                                                                                        Sign, Paperless!

                                                                                        Sign and send business documents on the go!

                                                                                        Get Started Now




                                                                                                Zoho TeamInbox Resources





                                                                                                          Zoho DataPrep Demo

                                                                                                          Get a personalized demo or POC

                                                                                                          REGISTER NOW


                                                                                                            Design. Discuss. Deliver.

                                                                                                            Create visually engaging stories with Zoho Show.

                                                                                                            Get Started Now








                                                                                                                                • Related Articles

                                                                                                                                • Lookup Field

                                                                                                                                  Lookup field allows users to associate an existing module with fields from the other modules. We currently support lookup fields in the task and timesheet layouts. Lookup fields are included in the total number of custom fields. A maximum of 5 lookup ...
                                                                                                                                • Integration Field

                                                                                                                                  Integration Field allows the users to update data from Zoho CRM. By enabling this feature, the user can establish a relationship between the data in Zoho Projects and the data in Zoho CRM. Your Zoho CRM portal should be integrated with Zoho Projects ...
                                                                                                                                • Time Logs List View

                                                                                                                                  Projects involve multiple activities by a number of people. These activities are time-sensitive and must be monitored to keep costs and timelines on track. Time logs are used to track the amount of time spent on various activities. Users can log time ...
                                                                                                                                • Connect Module Field

                                                                                                                                  Connect Module field allows users to link records across different modules in Zoho Projects, helping users establish relationships between related work items. Both default (phases, tasks and issues,) and user defined custom modules can be linked to ...
                                                                                                                                • Zoho ERP Integration for Zoho Projects

                                                                                                                                  Zoho ERP integration enables users to manage quotes, invoices, budgets, and expenses from within Zoho Projects. Finance and Expense features are available as separate tabs within a project. This Feature is only available in IN DC. Prerequisites Zoho ...
                                                                                                                                  Wherever you are is as good as
                                                                                                                                  your workplace

                                                                                                                                    Resources

                                                                                                                                    Videos

                                                                                                                                    Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                    eBooks

                                                                                                                                    Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                    Webinars

                                                                                                                                    Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                    CRM Tips

                                                                                                                                    Make the most of Zoho CRM with these useful tips.



                                                                                                                                      Zoho Show Resources