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
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
We are delighted to announce an Early Access to Zoho CRM for Everyone— a truly democratic approach to managing a CRM, gift-wrapped in an exciting and intuitive user interface. Here, multiple teams across an organization can coordinate among each other[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 DataPrep 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
Error 403: Forbidden When Updating Email Signature via API
Hi Zoho Desk team, First, congratulations again on the excellent Zoho API. But, I’m encountering an issue while attempting to update an email signature via the API. Whenever I make a request to update the signature, the response returns an HTTP 403 ForbiddenIntroducing LeadChain in Bigin to sync leads from Social Ads easily
We're excited to introduce a new topping in Bigin called LeadChain by Zoho Social. LeadChain instantly syncs lead information from social media lead ads to Bigin, making it easier to turn them into customers. It also helps you send conversion data backOffice 365 or Outlook?
Hello I'm just setting up IMAP integration with our CRM for the first time since we changed to using Outlook via a Microsoft 365 account. I have the choice of 'Office 365' or 'Outlook'. Which should I choose? ThanksRequest for Information on Zoho Desk Webhooks Availability and Security
Hi Team, We need some information regarding Zoho Desk webhooks. Could you please provide details on the following: Event Order Guarantee: Does Zoho guarantee that Desk events will always be processed in the exact order they occur? For example, if twoIntegration of WhatsApp with Zoho Commerce for Customer Support
I am looking to integrate WhatsApp Plus into my Zoho Commerce store to enhance customer support and communication. Specifically, I want to know how to set up WhatsApp chat for real-time assistance on product inquiries, order tracking, and post-purchaseClient Script | Update - Introducing Subform Events and Actions
Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms? We are thrilled to introduceTrying to find out the best solution for Travel booking/event organization.
I've been looking for answer during some time, sadly, but couldn't find any. Probably someone has an idea? Would appreciate any tips. Example 1. The client is interested in booking an Hotel room. He fills out the web-form on the landing page of this particularUsing Custom Fonts for All Users without Installing on Each Users System
Hi, Couple of questions, is it possible to upload a Custom Font to Zoho Writer and have all users see/use that font without installing it manually on each users system? If so, does this need to be done by the Super Admin or can anyone with Admin permissionsCRM - QR Codes and Bar Codes
Hi I am using CRM to run my service team - Asset maintenance business We need to move to and generate a QR code for each Asset we look after. And we need Bar code reading for the testing we do. (pre-bar-coded sample bottles are provided by the lab) DoesAccess Tokens and Webhooks
I have a linux server application that I want to be able to talk to the cliq chatbot and get a response back to that linux server application. This is for the linux server application to check the chat/channel's message history in Cliq. The Zoho API consoleunable to add email aliases
Hi, just verified and set up my domain but whenever I try to add another email alias I get a rather unhelpful error popup just saying AS101, doesn't matter if I tick set as mailbox address or not.Collaborators can't see Zia
Hello Zoho Writer Team, I recently shared a document with a collaborator, but she mentioned that Zia is not active and unable to assist her in adding content. Could you please guide me on how to resolve this issue? Looking forward to your assistance.In what case it's better to use Developer Console? Only for marketplace?
As I can see from the documentation, the limitations are challenging. No Custom API No Page Variables No Custom Connections.Default Reminder for tasks set to Pop-up instead of email
Try to save a click every time we create a task we want it to default to pop-up instead of email. Also default is to have reminder unchecked anyway to change so reminder is checked and method is pop-up default instead of email? Attached picture. Thanks,Why wont Zoho Support Grammarly!! --- PLEASE VOTE FOR THIS to show Zoho we need this
The spell check and grammar in ZOHO are so buggy and a waste of time. Please support Grammarly! I'm sure I'm not the only one — there are other CRMs that support this. If you're not planning to add this feature, Please let others know before acceptingZoho Book not Connecting to Bank
Is anyone else having issues with Zoho Books connecting to their bank? We have not been able to connect to the Co-operative bank feeds since Dec. Zoho are blaming the Co-op but the Co-op says that it has to be a Zoho issue as no other accounting softwareDashboard Auto-refresh
Why is there no Auto-refresh on the Dashboard? People have been asking for the last 6 years for this function from what I can see in my reasearch, it seems like a very simple intergration for Zoho to achieve. on Sept. 2, 2014, this was added: SupportCan't connect to Blogger & Wordpress
Hello Zoho Support Team, Thank you for providing Zoho Writer—it’s a fantastic tool that I truly enjoy using. However, I’ve encountered an issue when attempting to connect it to Blogger or WordPress for automatic posting. When I try to establish the connection,Weekly Tips: SecurePass For Extra Security
Imagine sensitive data from your organisation sent via email is being accessed by unintended recipients. The sensitive data can range from Personal Identification Information to a tender quotation or a client’s NDA document. The unintended access couldMultiple Blueprints on different fields at the same time.
It looks only 1 Blueprint can run at the same time, it makes sense for many Blueprints on the same field (Eg. Stage). But what about multiple Blueprints on "different" fields? the multiple options must be available. (Eg. Stage, Documents Status, ContractChanging VAT start date
Good Evening, Kindly asssit with this issue. 1. When setting up, I set my start vat date as October 29th. The system as has taken my month end date as 29th instead of either 30th or 31st depending on the month. 2. IS it possible to file past months atHeaders in Subfrom - Zoho CRM
Currently we cannot add any headers to CRM Subform If we have very large subforms and we want to logically group the rows it becomes really hard to do it Please add a header feature so we can add headers to a subform to logically and visually group differentBank entriy is nov month why this shifted to jan 2025 month
bank entries for november month i entered but why this is transfer to jan 2025 month.Migrate email domain from old .yyy to .zzz over time using aliases
Hi, I have an email domain that I've used for a long time that I'd like to migrate from. I have purchased a new domain and over time would like to use the new user@newdomain email address. I would prefer to have the alias point to the old (in use) addressmx
hello please if shopify domain doesn't allowed forwarding email when ensuring it with zoho mx what's other alternative options?Delay in Listing Customer data while creating transaction
After importing customer data into Zoho Books, I attempted to create an invoice but couldn't find the display name in the search results. However, it appeared when using the advanced search. When I manually add a customer name, the display name becomesThis Operation has been restricted. Please contact support-as@zohocorp.com for further details
Hello, I get the error This Operation has been restricted. Please contact support-as@zohocorp.com for further details. I have attached an error image to this email, and my domain name is 27investments.com.vn I hope to receive support from you. BestZoho Mail blocked by SpamCop/Mimecast 136.143.188.16
I cannot send emails to people whose domains use Mimecast or other systems that read SpamCop. This isn't the first time that this has happened. Please arrange a fix ASAP. ThanksCan sent or receive email from certain domain
Hi i have a problem with emails that have ...@otenet.gr. Otenet is the biggest provider in Greece but i can't communicate with its emails. (Message rejected due to: domain owner discourages use of this host Remote-MTA: dns; mx.otenet.gr) Please help Thanksexisting warehouses need to be migrated to the Locations module
Upgrade to Locations We've enhanced the Branches module to include warehouses and renamed it as Locations. To enable the Locations feature, your existing warehouses need to be migrated to the Locations module. Once migrated, these warehouses will appearTransaction Rules & Customer Payments
So I have a situation as follows. We have many clients who are all invoiced on the 1st of each month on a recurring invoice for 1 of 10 plans. This means that almost all payment dates are the same (some people pay late) and that a lot of the amounts areUser Filter for Dynamic Date Dimensions in Zoho Analytics
One challenge I frequently encounter is the need to create multiple versions of the same report—one for yearly data, another for quarterly data, another for monthly, and so on. While this works, it leads to unnecessary duplication, making maintenanceZoho CRM Mobile App Calls Module Missing
Hello all, After the last update I have two things. 1. I do not see the calls module at all - not via search, not anywhere 2. In home I do not see any scheduled calls, tasks, etc. If this in the new update or is my app gone wrong somewhere?Show value in a field based on selection
Hello, I'm new at Zoho Forms, I'm trying to do the following: Let's say there are two fields, (A) is a drop-down list for items, and field (B) is for a dedicated code of each item. Is it possible to apply a conditional logic once you select an item fromManage a rental inventory
Hi Zoho team, We have a company that is renting furniture and decor in the event industry. 1. Can Zoho Inventory manage inventory for rentals? 2. If no, can we create some features with Zoho creator that can integrate with Inventory to manage our rentals? 3. We have 2 warehouse, can we easily do inventory transfer between warehouse? Thank you for for help, PeterZoho Sign up forms on Wordpress website not working smoothly
We have set up the forms on the website and linked them to respective email journeys. But when wesubmit the form the email generated/sent to user is not consistent. Sometimes the journey email is sent, sometimes a email verification message is sent ,Zoho Deluge Online Training Workshop 2025
Master Deluge and Automate Zoho Applications An Extensive Online Training The Zoho Deluge Online Training is an extensive 2-day workshop designed specifically for developers, business users, and automation enthusiasts who want to master Deluge—Zoho’sPossibility to show Images during Blueprint Transitions
We use Blueprints heavily in our business to keep a structured process and to use a lot of automations. In fact, we automated so much, that our co workers sometimes don't know what really is happening. It would be helpful if we could show the users aZoho User Group Meetups 2025: Mis de eerste editie van het jaar niet!
Beste Zoho Dutch Community, Bij Zoho geloven we in het belang van het aanbieden van gratis trainingen, zodat u het meeste uit uw Zoho Apps kunt halen bij het beheer van uw bedrijf. Daarom komen de ZUGs (Zoho User Groups) Meetups in maart terug naar NederlandAccessing Attachments in Zoho Recruit Extension for API Integration
Hi, I am currently developing a Zoho Recruit extension to integrate with a third-party application. As part of this, I need to retrieve the attachment file from the current record and include it in an API request. However, I couldn’t find a relevant ZohoNext Page