AnsweredAssumed Answered

Return field name of field with lowest value

Question asked by CSTate on Feb 7, 2017
Latest reply on Feb 8, 2017 by 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.

Outcomes