0

I am trying to capture the max number value of 3 custom fields, then output the field name/label of the winner. What's the best way to do this?

Right now I got:

Max(Field A, Field B, Field C) and its correctly show me the highest number between the 3, BUT, I want to show the field name/label, instead of the max numerical value. Is this possible with some manipulation, if so, how?

Maybe:

If (Max(Field A, Field B, Field C)= Field A, “Field A”, 
If(Max(Field A, Field B, Field C)=Field B, “Field B”, 
If(Max(Field A, Field B, Field C)=Field C, “Field C”, No Value Set)
)
)
1
  • To include more information, do not use comments, but edit the existing question.
    – sfdcfox
    Apr 22, 2018 at 3:49

1 Answer 1

1

Yes this is possible with a formula you just need to make sure Text is returned with your value - For example - If you wish to add your own label to each Max value out of Three custom fields - you can use the following formula :

IF(MAX(Field_A__c,Field_B__c,Field_C__c)= Field_A__c,"Value A Is the Max = "+ TEXT(Field_A__c),$Label.OtherValue)
  • You can also add custom label as shown $Label.OtherValue

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .