topic Re: How to create an expression that returns count of fields with a greater than 0 value? in ArcGIS Online Questions

How to create an expression that returns count of fields with a greater than 0 value?

JamesPreston1 — Thu, 20 May 2021 02:57:45 GMT

I want to use Arcade to create a pop-up expression field that is a count of some other fields in the dataset that have a non-zero value. For example:

field_1	field_2	field_3	field_4	field_5	field_6	custom_field
0	0	4	4	0	1	3
1	1	2	4	0	4	5

This would be similar to what the COUNTIF function does in excel.

I have a small amount of experience in Arcade, and played around with incrementing a variable based on the result of an IIF statement:

var index = 0 iif($feature["field_1"]>=1, ++index, 0); iif($feature["field_2"]>=1, ++index, 0); return index

This just ends up giving a value equal to the number of IIF statement in the code, regardless of whether they evaluate to true or false. I have also tried other variations on this, but no luck. I am assuming that the trueValue of an IIF statement can't be used to increment a variable. This would make sense as the expression evaluations are treated as returns.

Any help would be greatly appreciated.

Re: How to create an expression that returns count of fields with a greater than 0 value?

JohannesLindner — Thu, 20 May 2021 05:59:17 GMT

var index = 0 if($feature["field_1"] > 0) { index += 1 } if($feature["field_2"] > 0) { index += 1 } return index // if the fields can be null: if(!IsEmpty($feature["field_1"]) && $feature["field_1"] > 0) { index += 1 }

Re: How to create an expression that returns count of fields with a greater than 0 value?

JamesPreston1 — Sun, 23 May 2021 20:54:58 GMT

It works! Thank you so much, @JohannesLindner.