Forum Discussion

DavisWard's avatar
DavisWard
Qrew Trainee
2 years ago

Formula Help - Getting a Field Name based on Maximum value

Here is my formula, which returns the value of the maximum. But I'd like the field name of the maximum: If([Sample Size]>1,ToText(Max([Bird Damage],[Bruise],[Corking],[Decay],[Discoloration],[Growt...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago
Try this, assuming that you already have a field called [max Value] to calculate the Maximum

List(", ",
Case([Max Value],

[Bird Damage], "Bird Damage",
[Bruise], "Bruise",
etc
[Glass/Metal/Rocks/etc.], "Glass/Metal/Rocks/etc."))

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • DavisWard's avatar
    DavisWard
    Qrew Trainee
    2 years ago
    That did the trick. I had to add a "Max Value" equivalent field. I was just attempting to do it without a middleman field.

    Thanks!

    ------------------------------
    Davis Ward
    ------------------------------