Can we have rule formula to support Minimum, Maximum and Mean value of various fields on a row of record?


We had a use case to understand what is the least metrics out of 10 different measures fields on a row of record and we couldn’t find a respective formula on rules under Number or Statistics ? 

Instead we developed alternative workaround like replacing every field value to multiples of 10s 100’s 1000’s and then summed up to say under which color category do they fall part (mapping the least to RED). If there was a Minimum or Maximum or Mean kind of formulas would have made it ease for these request.

@narayanan_s You should have those values on the field itself.  Does that solve what you are looking for?

 

 


@narayanan_s You should have those values on the field itself.  Does that solve what you are looking for?

 

 

That solves for column level on different set of records but when the ask turns within a single record set having 10 different number fields, we need to find the least out of 10 fields for one customer or relationship becomes tedious.


hope we could move this as idea if there is no other options. Thanks!

@sai_ram 


Hi @narayanan_s 

Thats a good idea. We will consider this one as we evaluate our platforms formula capabilities holistically. 

 

@All, do upvote it if you also faced this challenge. 


Thanks @rakesh 

upvote done from my end. 


+100 this is a must specially for automating health scorecards. Thank you!


While we’re at it can we get a SUMIF/SUMIFS function as well? IF statements?


+1


Surprising it’s not been included in the product already, but +10000000000000000 on this.