Show error message, if rule is automatically applying "min" function on the SFDC formula field

Related products: None

Hi Team, 

One of our team member has noticed an issue while using agregation in rules. 

A formula field in sfdc doesn't allow “grouping by” formula field. Hence, internally the rule is applying 'min' function on that field while querying which results in the behaviour customer is seeing. We are expecting a warning/ error message to be displayed in order to avoid the rework involved.

Use case: When we are aggregating on a field of segment (for an account manager), even though there are multiple segments for the given account manager it shows only 1 segment and the overall count in my initial fetch. As a work around, we have to create 1 more transformation and doing similar aggregation to get the correct output. 

Impact : This is creating 2 steps when this can actually be accomplished in a single step and manuall work is increased

 

Best,

Hardik

Hi @hardik_mota 

Thanks for bringing this up. I will look into this and explore how we can make this better.