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
Hi @HomesickSurfer
Here's an example of how I'd do this:
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.
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:
IFContains([RISK LEVEL]+[CARI Risk]+[Rush Deal Risk], "H") THEN "H"ELSEIFContains([RISK LEVEL]+[CARI Risk]+[Rush Deal Risk], "M") THEN "M"ELSE[ASSIGNED RISK]ENDIF
Happy to help!
