Arcade expression for area ranges (max and min) with Null values in labels

DianaWilson1 — Thu, 19 Nov 2020 21:35:18 GMT

Hi All,

I am working in a arcade expression for label the size range for each parcel with multiple buildings with different size. I have 4 fields: "Area1", "Area2", "Area3", and "Area4". There are null values in the within the fields. I wrote those expressions, but they do not work. could you please review it and let me know how will be the right expression.

If(!IsEmpty($feature.AREA1)) {return($feature.AREA1)}

else if (!IsEmpty($feature.AREA2)) {return($feature.AREA2)}

else if (!IsEmpty($feature.AREA3)) {return($feature.AREA3)}

else if (!IsEmpty($feature.AREA4)) {return($feature.AREA4)}

The other expression is:

Min($feature.AREA1,$feature.AREA2,$feature.AREA3,$feature.AREA4)+"-"+Max($feature.AREA1,$feature.AREA2,$feature.AREA3,$feature.AREA4)

With the second expression, as an example I get expression like 0-1050. but I do not want to get the "0", just because there is a null value in the "Area1"

Any advice? thank you!

Re: Arcade expression for area ranges (max and min) with Null values in labels

XanderBakker — Thu, 19 Nov 2020 22:48:31 GMT

Hi @DianaWilson1,

See my answer shared in your other post here: https://community.esri.com/t5/arcgis-pro-questions/arcade-expression-for-area-ranges-max-and-min-with-null-values/m-p/1003193

topic Re: Arcade expression for area ranges (max and min) with Null values in labels in ArcGIS Online Developers Questions

Arcade expression for area ranges (max and min) with Null values in labels

Re: Arcade expression for area ranges (max and min) with Null values in labels