AnsweredAssumed Answered

Finding the highest value

Question asked by gerrit.vaneijk@gallagher.com on Nov 16, 2016
Latest reply on Aug 14, 2017 by emha

Hi

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 .

 

Thanks

Outcomes