Max value of multiple fields containing L, M, H (Low, Medium, High)

[HomesickSurfer]

Hi

Looking for a clean way, without several tools and additional fields, to evaluate the maximum risk of L,M,H (Low, Medium, High) from 3 fields.

eg. Field4 should be H

Field1	Field2	Field3	Field4
L	M	H	H

[Luke_C · Accepted solution]

Hi @HomesickSurfer 

Here's an example of how I'd do this:

[Christina_H · Accepted solution]

Two solutions here, trying to minimise the number of tools/fields.  If you only ever have 3 fields going in you can do it in a single formula tool.  If you're not sure of the number, the other solution should work for any number.

[HomesickSurfer]

Thx @Luke_C and @Christina_H , both will work and I will consider their effectiveness.

I've tentatively opted to go with a single formula expression as follows:

IF
Contains([RISK LEVEL]+[CARI Risk]+[Rush Deal Risk], "H") THEN "H"
ELSEIF
Contains([RISK LEVEL]+[CARI Risk]+[Rush Deal Risk], "M") THEN "M"
ELSE
[ASSIGNED RISK]
ENDIF

[Luke_C]

Happy to help!