Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Re: Formula Help - Getting a Field Name based on Maximum value

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

1 Reply

  • DavisWard's avatar
    DavisWard
    Qrew Trainee
    4 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
    ------------------------------