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
Solved! Go to Solution.
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",
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",
Thank you very much @ZachBodenner . Such a silly mistake.
No worries, I do the same thing routinely.