I'm trying to use Arcade to create labels that show the highest value from a number of fields.
- Field 1 (number field) contains the value -2.7
- Field 2 (number field) contains the value -2.5
- Field 3 (number field) is empty (NULL)
If I use the following expression:
Max (Field1, Field2, Field3)
I get "0" as a result, when I expect to get -2.5 as a result. How can I create an expression that ignores the NULL/empty field?