AnsweredAssumed Answered

Finding the highest value

Question asked by on Nov 16, 2016
Latest reply on Aug 14, 2017 by emha


I have a number of fields where users can choose from option A to E, with A being the highest value.  I need to find out what the highest value is that has been chosen out of any of these fields.


For example:

Field 1 value chosen B

Field 2 value chosen E

Field 3 value chosen A

The highest value is A, which is in field 3.

Field 1 value chosen C

Field 2 value chosen B

Field 3 value hosen D

The highest value is B, which is in field 2


Is it possible to get these fields into an array or set of value that I can sort and then pick the highest or something.  Any help is highly appreciated .