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],[Growth Crack],[Hail Damage],[Insect Damage],[Leaf/Limb Rub],[Mechanical],[Mixed Sizing?],[Mold],[Open Suture],[Potato Skin],[Russeting],[Scar],[Shriveled],[Silvering],[Slip Skin],[Soft],[Soft Tip],[Speckling],[Split Pit],[Staining],[Stem Pull],[Sun Burn],[Undersize],[Worm],[Worm Hole],[Glass/Metal/Rocks/etc.])),null)

------------------------------
Davis Ward
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    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
      ------------------------------