Take the greater of two fields

[IJH34]

I would like to create a field that takes the greater value from two additional fields....see below

Field 1	Field 2	Greater
158	325	325
198	100	198
658	563	658
871	999	999
598	432	432

[OllieClarke · Accepted solution]

Hi @IJH34 You can use the MAX() function like so:

Hope that helps,

Ollie

[IJH34]

Wow! Didn't even know there was a max function. Thanks!