topic Re: Arcade When() function not working with complex And statement in ArcGIS Pro Questions

Arcade When() function not working with complex And statement

MPach — Fri, 31 Jan 2025 19:32:34 GMT

I'm trying to use a custom Arcade expression in Symbology to set the color of points in a feature layer. See below.

When($feature.Device_Due_Date > DateOnly(), "In Compliance",$feature.Device_Due_Date < DateOnly() && $feature.Device_Last_Test_Status = "fail", "Failing and Past Due", $feature.Device_Due_Date < DateOnly(), "Past Due", $feature.Device_Status = "Inactive")

I've narrowed the problem down to the complex AND statement on the second clause in the When statement. If I make it a simple clause without the AND it works.

Is there a way get the AND statement to work? I'm trying to set the color of the points based off of these logical statements.

Here's a screen shot to see where I'm using the expression.

Thank you

Re: Arcade When() function not working with complex And statement

ZachBodenner — Fri, 31 Jan 2025 19:39:31 GMT

What's the error you're getting? I think there's a chance it's because you use

$feature.Device_Last_Test_Status = "fail",

when you need two equals signs:

$feature.Device_Last_Test_Status == "fail",

Re: Arcade When() function not working with complex And statement

MPach — Fri, 31 Jan 2025 20:01:04 GMT

Thank you very much @ZachBodenner . Such a silly mistake.

Re: Arcade When() function not working with complex And statement

ZachBodenner — Fri, 31 Jan 2025 20:46:47 GMT

No worries, I do the same thing routinely.