topic Re: Sum ARCADE with condition in ArcGIS Online Questions

Sum ARCADE with condition

AurelienJOSSET — Sat, 01 Apr 2023 22:22:06 GMT

Good morning, I'm looking to make a rather simple ARCADE formula:

the sum of the Shape__Length field with a filter on one field (frequency different from 0 in my case)

Here is where i am now

var Sum =Sum($layer, "Shape__Length")

var filter = Filter(Sum, $feature.FREQ_ENTRETIEN !=0)

return filter

thanks a lot for your help

Aurelian

Re: Sum ARCADE with condition

JoshuaSharp-Heward — Sat, 01 Apr 2023 22:34:54 GMT

Hi Aurelian,

I think it'd work if you just flipped the first two lines, filtering the $feature.FREQ_ENTRETIEN !=0 values out before you sum them. Just make sure to then put the filter variable into the sum function instead of $layer.

Cheers,

Josh

Re: Sum ARCADE with condition

Omar_A — Sun, 02 Apr 2023 08:42:26 GMT

Hi Aurelien,

The expression you have created is almost correct but needs a small correction to filter the layer before summing the Shape__Length field.

var filter = Filter($layer, $feature.FREQ_ENTRETIEN != 0);

var Sum = Sum(filter, "Shape__Length");

return Sum;

Best,

Omar

Re: Sum ARCADE with condition

AurelienJOSSET — Sun, 02 Apr 2023 19:43:47 GMT

Hello to both of you

Thanks for your help.

The solution was ultimately

var filter = Filter($layer, 'FREQ_MAINTENANCE <> 0');

var Sum = Sum(filter, 'Shape__Length');

return Sum;

In the Filter function, the condition must be in SQL.

Again thanks to you

Bye