Introducing Rollup summary in Zoho CRM
------------------------------------------Moderated on 5th July'23----------------------------------------------
Rollup summary is now available for all organizations in all the DCs.
Hello All,
We hope you're well!
We're here with an exciting update that goes right into CRM's core capabilities. It's called the Rollup summary.
Let's go!
Your CRM is a vast database with well-connected data sources, where you can access both the primary and associated information from one place.
Consider the Leads module, for example. A lead record encompasses information about the lead, their activities, and other applicable information, enough to decide upon the next move. This sort of association forms the foundation for data accessibility.
Your CRM is a vast database with well-connected data sources, where you can access both the primary and associated information from one place.
Consider the Leads module, for example. A lead record encompasses information about the lead, their activities, and other applicable information, enough to decide upon the next move. This sort of association forms the foundation for data accessibility.
However, when it comes to effective data management, mere association alone is not adequate. You need what is called an interoperable data relationship between your primary and associated data. In the CRM context, an ability to associate values from the related lists with the primary information itself is the premise of the Rollup summary.
Rollup summary
Rollup summary
Rollup summary is a field type that can summarize or aggregate values from your desired related list. It is adaptable and versatile. All you have to do is to choose which property to aggregate from your related list and assign that to the field, the field will start rolling up values.
Let us look at different scenarios where rollup summary can benefit you:
Example 1: Aggregate account-based revenue
The accounts module in your CRM holds business information about your prospects and customers. It also displays the contacts, deals, quotes, invoices, and other information associated as related lists.
Example 1: Aggregate account-based revenue
The accounts module in your CRM holds business information about your prospects and customers. It also displays the contacts, deals, quotes, invoices, and other information associated as related lists.
Now, to assess the account's contribution before signing a purchase agreement, the sales manager had to create a report and aggregate the values separately.
With the rollup summary field added to the module, you can get an auto-assimilated value of invoices created for the account. This saves a lot of time and effort invested in creating reports and the best part is that the field, upon addition, will be available for all records in that layout.
Using this computed value in the rollup field, you can create automation, create a review process, and so on.
Example 2: Take action on the untouched deals
Untouched deals are deals without any actions till time. These kinds of deals are not only stagnant but are also unfavorable for business. However, for an enterprise business that creates more deals each day, manually identifying untouched deals and following up could be a missed opportunity, already. To keep a constant eye, you can create a rollup field that displays the number of untouched deals in your contact records and quickly follow up or automate.
Example 3: Get to know overdue tasks
Tasks are a great way to plan your actions that also act as a reminder. In Zoho CRM, when you add a task it will be added to the open activities related list. Until a task is completed, the task won't be moved to the closed activities. But, due to some lapse, if the rep couldn't complete the task on time, the task will remain in the open activities, giving an impression that the task has time left and as a sales manager, you might want to know of such cases in the leads module. This is where the rollup field will come in handy. With rollup being a field, you can use that as a column and filter the records with values in it.
Tasks are a great way to plan your actions that also act as a reminder. In Zoho CRM, when you add a task it will be added to the open activities related list. Until a task is completed, the task won't be moved to the closed activities. But, due to some lapse, if the rep couldn't complete the task on time, the task will remain in the open activities, giving an impression that the task has time left and as a sales manager, you might want to know of such cases in the leads module. This is where the rollup field will come in handy. With rollup being a field, you can use that as a column and filter the records with values in it.
Likewise, you can add a rollup field type to your layout editor and get value assimilated as a read-only field in your record detail page.
Note:
Currently, the rollup summary field property will list only fields that are part of the system-defined related list belonging to a module.
Pre-requisites:
- Rollup field is available in all modules except in tasks, calls, meetings, and appointments.
- Rollup summary field type is available only for organizations with Enterprise and Ultimate editions of CRM. You can create up to 10 rollup fields per module for Enterprise and 15 for Ultimate edition.
That's about rollup summary. We hope this new feature will help you conduct cumulative analyses effectively. While this is just the first cut of the release, we are planning the following enhancements:
- Customization capabilities: We are developing the ability to customize and configure your own rollup summary field. This enables you to aggregate different parameters for different related lists.
- Rollup as a workflow trigger: In addition to using the field as criteria in a workflow rule, we are developing to base workflow automation upon a rollup field as a rule condition itself. This will enable you to create automation exclusively based on a rollup field.
Resource: Help document
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Saishree T K
Nick
Kevin Flynn
Sukumar
Jordan Talmor
Sticky Posts
Announcing Early Access to "Zoho CRM for Everyone" — A new and exciting update to Zoho CRM
Update : Zoho CRM For Everyone's Nextgen Interface gets an upgrade! Hello everyone, We’ve updated the Zoho CRM for Everyone Nextgen interface based on your feedback. The UI is now simpler with a unified sidebar, a more visible global search and features[Early Access] Voice of the Customer (VoC) for Zoho CRM
Happy new year, everyone! We have an exciting addition to our suite of features and would like to introduce you to VoC (Voice of the Customer) for Zoho CRM, powered by Zia. 2023 is definitely the best time to be a customer with rapid innovations and advancementsAdding calls as a channel in Voice of the Customer
Dear All, We hope you're well! It's been almost a year since we opened Zoho CRM's Voice of the Customer solution up for early access. We are grateful for the reception and support you have been showing us with regards to its adoption and feedback. Since
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Frustrated with Zoho Assist QuickSUpport
Trialling Zoho Assist and I have a variety of clients. A lot are computer illiterate. Some have poor vision. The current support sessions are using apps which have desktop icons for the appropriate apps. I either connect on demand then the client approvesCRM x WorkDrive: We're rolling out the WorkDrive-powered file storage experience for existing users
Release plan: Gradual rollout to customers without file storage add-ons, in this order: 1. Standalone CRM 2. CRM Plus and Zoho One DCs: All | Editions: All Available now for: - Standalone CRM accounts in Free and Standard editions without file storageZoho CRM Copilot Connector
Hello, Are there plans to release a connector for Zoho CRM and Copilot? I'm in the early research stages of potentially switching our CRM solution to Microsoft Dynamics because of its out of the box integration with Copilot. The advantage being that weZoho Projects - Will there ever be a send email feature in Zoho Project?
Hi team, Are there plans to or will there ever be a sendemail feature in Zoho Projects, brining it in line with other similar platforms like Asana, ClickUp and Monday? I know that you can add comments via email to a specific task, but I believe this onlyIntroducing Microsoft Word Integration in Zoho Contracts
We are excited to announce a new feature that brings contract authoring and negotiation in your familiar environment — the Microsoft Word Integration. What This Integration Brings The Microsoft Word Integration connects Zoho Contracts with the MicrosoftShare Video Response Card ion Zobot
I am using the zobot codeless bot builder in SalesIQ. I want to share a video but delay the next response card until after the video has finished playing or has been stopped. Is this possible?Customer image field
I created a custom image field for estimates, and it works as expected. The only issue I have is that I want to be able to place the custom image field in the estimate invoice. Is there a way I can do that, the field does not give the option to displaySub Folders
It would be great if there could be sub-folders in reports. We have a ton of individual reports and folders that would be easier to navigate this wayGoals API - Zoho People
Hi Team, I would like to get the API details for retrieving organisation-wise Goals from Zoho People. Currently, I am able to retrieve individual employee goals using the following API: https://people.zoho.com/api/v3/performance/goal/{emp_id} However,Question and responses disapear
I have a form where several people have had issues where the questions, responses or submission simply disappear when trying to complete the form. It seems to be random with no pattern of question, browser or OS. Hopefully there is a fix in the platformUnable to send message;Reason:553 Relaying disallowed. Invalid Domain
Hi, Now when I try to reply to an email, I see the Unable to send message;Reason:553 Relaying disallowed. Invalid Domain voicemessagedownloader.com error. I tested sending an email when I set it up in the past and it worked. I have checked the Zoho OrganizationGuide customers to the right booking page with routing forms
Greetings from the Zoho Bookings team! We're excited to introduce Routing Forms in Zoho Bookings. Routing forms let you collect information from customers before they schedule an appointment and automatically direct them to the most appropriate bookingAnalytics Dashboard User Filters Default Value
User Filters on Dashboard do not allow Unknown to be set as a default filter value. I have to include NULL values in my dashboard among other values but I can't include NULL/Unknown by default in Dashboard User Filters.Horrible download speed
Using a trial of Zoho Assist and downloading a 316 MB file on a 500/500 fibre connection to a remote computer on the same network took 7 mins to complete. On AnyDesk it took 1 min or so.How to Backup Zoho to PST?
I'm looking for a simple way to backup Zoho Mail emails to PST format. I tried the IMAP method with Outlook, but it seems slow and complicated for large mailboxes. I need a solution that can: Export Zoho emails to PST Preserve attachments and folder hierarchyZoho Books | Product updates | August 2026
Hello users, July has been an exciting month for Zoho Books! This month, we're excited to introduce HTML PDF Templates, Placeholders as Pills, expanded approval workflows for Sales Returns and Journals, and significant compliance updates across the India,Action required: WhatsApp now uses BSUID as the primary identifier
Important If your support team uses WhatsApp to engage with customers, there is an important platform change you need to know about. BSUID support is now mandatory for all WhatsApp Business Platform partners and businesses. WhatsApp is introducing usernames,Tip #83- Give Customers a Faster Way to Reach You with the Quick Support Plugin – 'Insider Insights'
Hello Zoho Assist Community! Think about the last time a customer needed urgent support. They emailed in, waited for a response, got a session link, couldn't find it in their inbox, called back, and by the time the session actually started, a good chunkFinal Notice: Migrate Your ASAP Mobile SDK by August 31
Alert August 31, 2026 is the deadline. After this date, older ASAP Mobile SDK versions will no longer work with the ASAP Help Widget. If your app hasn't been migrated to a supported SDK version, users will no longer be able to access the ASAP Help WidgetApproval Process configuration is now more flexible and fully customizable
Hello everyone! Zoho CRM's Approval Process is back with a better user experience that makes it easier to add rules to your processes. This enhancement includes some UI updates that help you create highly structured approval stages—and more. Let's lookKaizen #255 - Building a Real-Time Operational Dashboard with Zoho CRM Queries
Hello Everyone, Welcome back to another edition of the Kaizen series, where we uncover powerful ways to extend and customize Zoho CRM. In the previous Query Kaizens, we explored how Queries can retrieve CRM data, invoke REST APIs, and even update CRM【Zoho CRM】キオスクに「ループ機能」が追加｜同じ処理を繰り返し実行可能に
ユーザーの皆さま、こんにちは。 コミュニティグループの中野です。 Zoho CRMのキオスクに、同じ処理を繰り返し実行できる「ループ機能」が追加されました。 これまでは、同じ処理を複数回実行したい場合、同じ設定を繰り返し作成する必要がありました。 ループ機能を使うと、処理を一度設定するだけで、指定した回数や 取得したデータ数に応じて自動的に繰り返すことができます。 目次 ループ機能とは 設定方法 注意点 1. ループ機能とは ループ機能を使うと、キオスク内の画面や処理を指定した条件に応じて繰り返し実行できます。Es posible cambiar el lenguaje de los modulos del ASAP?
Es posible cambiar el lenguaje de estos textos? Tengo Zoho configurado en español pero aun así me muestra estos textos en ingles:Where do I edit the "Welcome to [portal name]" message
I am looking for a way to edit the "Welcome to" part of the message that is seen on the landing page (ex: https://help.zoho.com/portal/en/home). When I use the French interface, it doesn't make sense... I want to change it from "Bienvenue chez" to" Bienvenue au". Thanks!Zoho ERP | Product updates | July 2026
Hello users, We're back with another round of updates to help you streamline your operations. This month's release brings new features and enhancements designed to help you work more efficiently. Read on to discover everything that's new in Zoho ERP thisAutomate Backups
This is a feature request. Consider adding an auto backup feature. Where when you turn it on, it will auto backup on the 15-day schedule. For additional consideration, allow for the export of module data via API calls. Thank you for your consideration.Shared Snippets Everyone
Hi, Now that the Shared Snippets have been released and I think will be the most used feature implemented in 2023 :) Creating and Using Snippets in Ticket Responses - Online Help | Zoho Desk Maintain consistency in ticket responses with shared snippetsMulti-currency and Products
One of the main reasons I have gone down the Zoho route is because I need multi-currency support. However, I find that products can only be priced in the home currency, We sell to the US and UK. However, we maintain different price lists for each. ThereRemove "Subject" as a required field on quotations
Not sure why, but Zoho has made 'Subject' a system defined required field. I'm not entirely sure why subject would be required as a key field (i.e. you cannot deactivate it or change it from required). It doesn't make much sense on many product quotations,Displaying only unread tickets in ticket view
Hello, I was wondering if someone might be able to help me with this one. We use filters to display our ticket list, typically using a saved filter which displays the tickets which are overdue or due today. What I'd really like is another filter thatBest way to setup Inventory bin tracking for products with multiple boxes/crates
Hi - we need some advice from the community on setting up Items in the Inventory for products with multiple crates. We have large products in our warehouse where the product is delivered as two large (double pallet) crates. We've setup the Items for theseCan't find field from ZCRM for a trigger
Hello, Currently I am revamping our CRM system and we have created second layouts from to try out new processes while not disrupting the old one. Moreover, we want to use different layouts for different processes. The issue is that when creating the ZCRMDiscount Per Item / Option Removed
Hi, I was using Zoho Books for three years now and very saticfied. Now, as we try to add an invoice, we founds that the discount option per item was takn away, and a discount from total was implemented. However, we have cases when we add a diffrent discount to each item. Was this option removed permanently? Thanks,Any Possible to change the challan type in Delivery challan ?
Hello Team, We need to add the more values in challan type in delivery challan module in Zoho Books.So how to add additional values in challan type field. Please find following snap for your reference. Thanks in Advance, Thisai Moorthy.Show when an invoice has been viewed
It would be nice to know if/when a customer has viewed an invoice. This would mean not having PDF attachments and just have the link to the invoice. My previous invoicing solution had this feature and I did not realize how much I used it until it was gone. Would this be possible, or this already available and I am just missing it?Zoho Books | Product updates | March 2026
Hello users, We’ve rolled out new features and enhancements in Zoho Books. From Advanced Reporting Tags to the ability to mark projects as completed, explore the latest updates designed to improve your bookkeeping experience. Introducing Advanced ReportingSeparator line
Is there a way i can insert a line in an invoice or quote without showing qty or prices? e.g. Options I Item description qty and price Option II Item description qty and price ThanksAll new Address Field in Zoho CRM: maintain structured and accurate address inputs
Availability Update: 29 September 2025: It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition exclusively for IN DC users. 2 March 2026: Available to users in all DCs except US and EU DC. 24BCC Drop Box Centralisation
Hi Team, For the last few years, I have had a question related to the Zoho CRM BCC Dropbox feature. Although BCC Dropbox is very useful for tracking customer email communication, I have always wondered why its configuration is managed at the individualKiosk Page Refresh
We have a Kiosk running from a button in contacts to update values and also add related lists, which works great, but when the kiosk is finished the page does not refresh to show the changes. Is there a way to force the contact to refresh/update whenNext Page