I’m moving from Airtable to Baserow and I need to manually “rewrite” all the formulas.
I’m struggling with the MAX-function.
Suppose I have 3 numeric fields per record : FIELD1 FIELD2 FIELD3
How do I get the maximum value of these fields in a new field HIGHEST
(I tried max(field('FIELD1'),field('FIELD2'),field('FIELD3')) but I’m getting an error)
(I tried greatest(field('FIELD1'),field('FIELD2'),field('FIELD3')) but this can only be used with 2 parameters)
What’s the solution?
Hello @WimDC, can you please try this formula?
greatest(field('FIELD1'), greatest(field('FIELD2'), field('FIELD3')))
Hi @olgatrykush ,
thanks and this works, but this becomes quite complicated with more than 4 fields.
Maybe remove the limit of 2 parameters in the greatest-function
I’ll discuss it with the team 
Hello @WimDC, we think it would be good to adjust how the Baserow MAX function works so that it also supports numeric fields (currently it only works with lookups). This way, you’ll be able to use it to compare as many values as needed. Thank you for pointing our attention to this 