Zoho CRM: Condition based aggregate fields in subforms

Zoho CRM: Condition based aggregate fields in subforms

Hello everyone,

We're excited to inform you about the latest enhancements made to our aggregate field capabilities in subforms; create aggregate fields based on conditions!

An aggregate field is a column on which a mathematical function has been applied. If necessary, you can add an aggregate field after including the columns. Thus far, we have three types of aggregate fields for subforms:
  • Predefined functions: Easily apply common mathematical functions like SUM, AVERAGE, MAXIMUM, and MINIMUM.
  • Formula Functions: Customize your aggregates with personalized formula expressions.
  • Manual Entries: Keep things in your control by manually entering values.

What's New? 

Condition-Based Aggregate Fields: You now can customize your aggregate fields at an advanced level. In addition to aggregating data, you can also establish specific conditions or criteria to decide which entries should be included in the aggregation. This feature provides more precise control and allows for detailed data analysis.


Here's a closer look at the key highlights:
  • Criteria-driven aggregation: You can set specific conditions or criteria to filter and prioritize the data that is most relevant to you, rather than just collecting general information. The system will then gather and aggregate only the data that meets these conditions.
  • Distinct data views: This feature is revolutionary for datasets that cover various categories. If you have data that distinguishes between different categories, such as camera and photography devices, or printers and scanners, you can now easily separate and analyze these categories individually, guaranteeing clear and accurate insights.

How Will This Help?

  • Flexibility: Choose to aggregate either all row values or just specific ones based on your set criteria.
  • Precision: With the new criteria popup, you can specify which subform fields you want to consider, ensuring the results align exactly with what you need.

  • Efficiency: As you update or create new records, the system smartly calculates either all row entries or just the ones that match your conditions.
That's about the enhancements. Please let us know your feedback and thoughts in the comments below. 

    • Related Articles

    • Zoho CRM: Introducing Rollup summary

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

    • Zoho CRM: The Canvas Record Form for Enhanced Customization

      Zoho announced Zoho Crm innovation with Canvas functionality now extends to record forms, enabling you to personalize record entries with the power of Canvas! Enhancing CRM Interactions with CanvasIn the heart of any CRM lies the ability to manage ...

    • Zoho CRM: New Assignment Rules

      Zoho CRM is introducing a new feature to make assignment rules even more flexible and powerful. Administrators can now automate the assignment of records based on specific criteria. These criteria can be related to the fields in the record or the ...

    • Zoho CRM : Compliance Made Easy for Email Authentication

      We are introducing you with significant updates to enhance email authentication and verification processes across Zoho CRM and other Zoho services. These changes aim to bolster security, ensure compliance with industry standards, and improve user ...

    • Zoho Analytics 6.0 Beta: A New Era in Data Analytics

      Zoho has introduced Zoho Analytics 6.0 Beta, a significant upgrade tailored to the diverse needs of business users, data analysts, data engineers, and data scientists. This version incorporates extensive user and market feedback, offering innovative ...