Forum Discussion

Qrew Trainee

3 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

Qrew Legend

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

Qrew Trainee

3 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
------------------------------