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

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

Hope that helps,

Ollie