7 Replies Latest reply on Feb 8, 2017 3:12 PM by CSTate

    Return field name of field with lowest value

    CSTate

      I have a group of 80 fields all containing a numerical value (all in a single record). I want to know the name of the field with the lowest value (min). I have no problems identifying the lowest value but I am not having any success in returning the actual field name. Is there a way to do this either as a calculation or script? GetFieldName ( min ( field 1; Field 2; Field 3 ... Field 80)) returns a "?".

       

      Any help would be appreciated.

       

      Cheers

      Corey.