AnsweredAssumed Answered

Arcade expression that returns the "Maximum" value, but excludes NULL values.

Question asked by guivdko on Jan 7, 2017
Latest reply on Feb 13, 2017 by PBarker-esristaff

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? 

Outcomes