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
Unable to produce monthly P&L reports for previous years
My company just migrated to Books this year. We have 5+ years financial data and need to generate a monthly P&L for 2019 and a monthly P&L YTD for 2020. The latter is easy, but I'm VERY surprised to learn that default reports in Zoho Books cannot createChange Last Name to not required in Leads
I would like to upload 500 target companies as leads but I don't yet have contact people for them. Can you enable the option for me to turn this requirement off to need a Second Name? Moderation update (10-Jun-23): As we explore potential solutions forReply to Email for SO/PO
Hello, We are new to Zoho Books and running into an issue. Our support@ email is our integration user. When our team is sending out PO/SO's we are updating the sender email, but for some reason many of our responses are coming back to our support@ emailZOHO Payroll Canada
Any plans on the roadmap for Canada?What's New in Zoho Billing | January 2026
Excited about the latest enhancements in Zoho Billing? Our January updates bring an intelligent AI assistant, smarter subscription management, and improved tax compliance, saving you time and reducing manual work. Dive into the details below to see howZoho Books Sandbox environment
Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need aMulti-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. ThereCliq iOS can't see shared screen
Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? RegardsZOHO Writer Folders
Hi We would love to have ability to create folders on the left hand side. We would then be able create and store our documents within each folder Hope you can provide this feature soon ! dux.centraHow can Data Enrichment be automatically triggered when a new Lead is created in Zoho CRM?
Hi, I have a pipeline where a Lead is created automatically through the Zoho API and I've been trying to look for a way to automatically apply Data Enrichment on this created lead. 1) I did not find any way to do this through the Zoho API; it seems likeEscalation request: organization merge and data export (Ticket [154609577])
Hello Zoho Team, I am posting here because my support ticket has not received substantive responses through the usual channels. Summary of the issue (ongoing for three weeks): I requested assistance with a data migration and a merge of two Zoho organizations.Do buttons and vba msgbox work on mobile, specifially the iPhone zoho sheets app?
In Zoho sheets on the web, I inserted a button and assigned a VBA macro to it. It pops up a msgbox with some text. When I go onto the iPhone mobile zoho sheets app, the button is there. When I click on that button, the spinning asterisk appears for aDifferent form submission results for submitter and internal users
I'm looking for suggestions on how to show an external submitter a few results while sending internal users all the results from the answers provided by the external user. The final page of our form has a section with detailed results and a section withHelp Desk Services Solution
I am here looking for Help Desk services solution for organization. I also searched this on many different website and found many solutions. We are bit confused to which one to choose. One of my friend suggest me this platform, and i am hoping i willFormatting and slow
Creating campaigns are difficult. I'm fairly computer literate but some of the way Zoho Campaigns formatting works is painful. Images fail to upload or are very slow. To top it off, syncing the contacts is a pain as well as temperamental links to create Segments. At this rate I'm afraid we might need to migrate back to Mailchimp.Boost your Zoho Desk's performance by archiving tickets!
The longer your help desk operations are, the more likely it is to accumulate tickets that are no longer relevant. For example, ticket records from a year ago are typically less relevant than currently open tickets. Such old tickets may eventually leadPaste emails to create segment
We are moving over from Mailchimp to ZOHO. However Mailchimp allows me to create a segment by pasting in emails from excel (or importing a .csv) can I do the same in Mailchimp?Getting the Record ID of a form once it is submitted - so that form can be edited later
In Zoho Forms, where can I access the record ID of a form once the form is submitted? - Record ID is not available in webhook payloads - It is not available to form fields, including in formulas - It is not available as a parameter in a thankyou pageAuto-Generate Line Numbers in Item Table Using HTML & CSS Counters (Zoho Books & Zoho Inventory Custom Templates)
<div> <style> /* Start counter from 0 inside tbody */ tbody#lineitem { counter-reset: rowNumber; } /* Increment counter for each row */ tbody#lineitem tr { counter-increment: rowNumber; } /* Show counter value in first column */ tbody#lineitem tr td:first-child::beforePossible to define default font and size in Zoho Campaigns?
Is it possible to define a default font (font, size and colour) for the text, H1 and H2 in Zoho Campaigns? For example: In a campaign, I add a text block, and the text is automatically century gothic, size 11, grey (6f6f6e) by default? Thank you!Zoho Sites - General Feedback
Hi Everyone-- Quick question for discussion: is it me or is working with Zoho Sites like entering the Twilight Zone? I've built many sites over the years, but this platform seems impossible. I've spent an entire day and a half trying to get a simple one-colorFile Upload field not showing in workflow
Hi, I have added a field on Zoho CRM. I want to use it in a workflow where that particular field is updated based on another field, however it is not showing up in the field list to select it in the workflow. Why is this please?You cannot send this email campaign as it doesn't have any eligible contacts in the selected mailing list. You can try adding contacts or choose other mailing lists.
please helpStrengthening the capabilities of CommandCenter in Zoho CRM Plus
When you look at the prospect-to-customer journey in most businesses 10 to 15 years ago, it was relatively straightforward. Many of us remember walking into a store, sharing our requirements with a sales associate, reviewing a few options, and makingWorld date & time format
Hello, Is there a timeline to get the worldwide used date and time format ? I mean not the american one... I mean day month year, and 24 hours clock. RegardsAnnouncing Kiosk 1.1 - Customize screen titles, configure new fields & actions, use values from your Kiosk to update fields, and more.
Hello all We are back again with more enhancements to Kiosk. So what's new? Enhancements made to the Components Add titles for your Kiosk screens and adjust its width to suit your viewing preferences. Three new fields can be added to your screen: Percentage,Any recommendations for Australian Telephony Integration providers?
HI, I am looking for some advice on phone providers as we are looking to upgrade our phone system, does anybody have experience with any of the Australian providers that integrate with CRM Telephony? So far we are looking at RingCentral and Amazon Connect, and would love to hear feedback on any of the other providers you might have tried. Thank youZoho Campaigns Workspaces
Hi, I’m currently working on a Zoho CRM + Zoho Campaigns setup for a franchisee-based organization, where each franchise must only see and use its own contacts. At the moment, franchisees cannot properly access their contact lists in Zoho Campaigns unlessLimited System because of Limited Number of Fields for Car Dealership
Dear Zoho Support, we want to have all the information about a car inside of a car record. We want to have Zoho CRM as our single source of truth for our data, but the limited number of fields are not allowing that. The data consist of: technical dataZoho CRM for Everyone's NextGen UI Gets an Upgrade
Hello Everyone We've made improvements to Zoho CRM for Everyone's Nextgen UI. These changes are the result of valuable feedback from you where we’ve focused on improving usability, providing wider screen space, and making navigation smoother so everythingNewsletter in multiple languages
Hi We are planning on starting to use Zoho Campaigns for our newsletters. Since we send our newsletters in three languages, I would need the "unsubscribe page" and other pages related to the NL (Thank you page and so on) to be available in different languagesFixed assets in Zoho One?
Hi, We use Zoho Books and have the fixed asset option in it. I started a trial for Zoho One and I do not see that as an option. Is the books that is part of zoho one equivalent to Zoho Books Elite subscription or is it a lesser version? Thanks, MattSet Default Status of Assembly to "Assembled" When Entered in UI
I've just discovered the new "confirmed" status of Assemblies within Inventory. While I understand the intent of this (allowing for manufacturing planning and raw material stock allocation), it was initially confusing to me when manually entering someI need to Record Vatable amount and non vatable amount separately in zoho books in a single line
I need to Record Vatable amount and non vatable amount separately in zoho books in a single line give me the customisation option and in invoice copy to customer the total amount should be inclusive 5%vat and no need to show the vatable and non vatableSort Legend & stacked bar chart by value
I'd love to see an option added to sort the legend of graphs by the value that is being represented. This way the items with the largest value in the graph are displayed top down in the legend. For example, let's say I have a large sales team and I createScanned Doc - selecting Item overwrites Rate
I have a Vendor Invoice which was uploaded to Documents. I select Add To > New Bill. The OCR is actually quite good, but it is reading an Item Description instead of an Item Number. I remove the description and select the correct Item Number... and itTimesheet invalid data error
Getting the "Invalid Date" error when trying to add a time sheet to an appointment in a work order. I initially though the work order was corrupt or something so I deleted the work order and recreated it. I added the first time sheet to the AP and savedConvert invoice from zoho to xml with all details
How to convert an Invoice to XML format with all detailsAny update on adding New Customer Payment Providers who support in store terminal devices?
Currently there is only one Customer payment provider listed for terminal devices in USA- Everyware. They charge a monthly fee of almost $149 minimum. Will you add other providers - like Zoho Payments or Stripe or Worldpay that would allow integratedDealing With One-Time Customers on Zoho Books
Hello there! I am trying to figure out a way to handle One-Time customers without having to create multiple accounts for every single one on Zoho Books. I understand that I can create a placeholder account called "Walk-In Customer", for example, but INext Page