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 : 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 CRM: Global Sets
Hello all, We are thrilled to announce Global picklists, a much awaited feature for CRM Admins! As administrators who implement and manage CRM solutions, you may have dealt with picklists that are present across multiple modules and have the same ...Announcing a change to how null values in formulas are computed in Zoho CRM
As you all know, the formula field is a versatile field that enables you to perform varied computations, from simple math to concatenation to field value comparisons. To learn more about the different capabilities of formula fields, read Data types ...