Create custom rollup summary fields in Zoho CRM

Create custom rollup summary fields in Zoho CRM

Hello everyone,

In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules.

Previously, only predefined summary functions were available to track metrics, such as total deals, revenue per account, lost deals revenue, or maximum sales cycle duration, and so on.

However, beyond these general metrics, users would often need more customization capabilities to derive more tailored insights specific to business logic and client needs.

The solution: custom rollup summary fields

With our new custom rollup summary fields, you can now create summaries that reflect each industry's unique requirements. This enhancement enables more customized data views, which enables you to choose any related list and summarize any integer or date-based fields from it. 



Here's how the new roll-up summary creation flow works:

Once you drag and add a rollup summary field from the fields tray, the new rollup summary properties pop-up will ask you to configure the field per your requirements.


  1. Rollup related module: Select the related module whose records you want to summarize and choose either to create a custom rollup or use predefined rollup functions.
    1. Selecting "Create Custom Rollup" enables you to customize the function, field, and criteria per your needs.
    2. Choosing "Select Predefined Rollup" lets you select from the predefined rollup fields available in the Rollup Summary Field dropdown. Note that the old Rollup Gallery is no longer available.

  2. Function: Custom roll-up summary fields offer a variety of functions that enable teams to align data with their business objectives. The functions available depend on the selected rollup module.
    1. To summarize numerical data, you can use Sum, Average, Maximum, or Minimum.
    2. To summarize date-related data, you can use Earliest, Furthest, Recent, or Upcoming.


  3. Rollup field: Based on the selected function, only system-defined and custom fields relevant to that function will be available for selection.

  4. Additional criteria: You can add criteria to your rollup field to filter and aggregate only the most relevant data for your business needs.

    Without criteria, the rollup field calculates all related records, which may result in cluttered or less meaningful results.
Notes
Notes:
  • Rollup fields are available in all modules except Tasks, Calls, Meetings, and Appointments.
  • The Rollup Summary Field type is available only for organizations using the Enterprise and Ultimate editions of Zoho CRM.
  • You can create up to 10 rollup fields per module in the Enterprise edition and up to 15 in the Ultimate edition.
That's all for the enhancement. Please share your feedback and suggestions in the comments below. 
Feature availability and release plan
  • These enhancements are currently available for all eligible users across all DCs.

Thanks,
Nizamuddin


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方