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