Arcade Expression for conditions

[KhemAryal]

Hi 

I have data collected in the field as

Depth rim to invert (A)

Depth Rim to Debris (B)

Depth Rim to Bottom (C)

KhemAryal_0-1611701093634.png

I need Arcade expression for display as

If (C-B)>(C-A)/3              ‘Need Cleaning’

Else                                          ‘No Cleaning Needed’

Here is my expression

KhemAryal_1-1611701093640.png

The expression Test passed but doesn’t reflect the counts in the layers as there is one data that supposed to return “Cleaning Needed”. This is reflected as 'Other' with 0 counts.

Not sure what I am missing

KhemAryal_2-1611701093642.png

Thanks in advance

[DavidPike]

It looks fine to me, but the logical test is obviously failing on everything and the Else is being returned.

Perhaps it's a text field rather than a float/number?  Only other suggestion is to try returning debris, invert and your logical test to debug.

[KhemAryal]

Thanks @DavidPike 

The field type is not text but 'Double'

KhemAryal_0-1611762592780.png

Wondering how do you debug the logical test?

[DavidPike]

just label everything as debris, then invert/3 and see whats happening possibly.  maybe needs to be invert/3.0 if arcade is funny that way?

[XanderBakker · Accepted solution]

Hi @KhemAryal ,

If I look at your expression and the explanation it seems that you inverted debris and invert in the conditional statement.

var A = 2.50; // rim to Invert (A)
var B = 1.60; // rim to Debris (B)
var C = 3.50; // rim to Bottom (C)

var debris = C-A; // rim to Bottom (C) - rim to Debris (A)
var invert = C-B; // rim to Bottom (C) - rim to Invert (B)
Console("debris: " + debris);
Console("invert: " + invert);

// If (C-B)>(C-A)/3  'Need Cleaning'
// Else             'No Cleaning Needed'

Console("debris/3: " + debris/3);

if (invert>debris/3) {
    return 'Need Cleaning';
} else {
    return 'No Cleaning Needed';
}

This returns "Need Cleaning" and it writes the following to the console:

debris: 1
invert: 1.9
debris/3: 0.3333333333333333

[KhemAryal]

Hey XanderBakker

That expression now solved my problem. 

You are a GEM and a great resource for us in this forum.  

[XanderBakker]

You're welcome @KhemAryal . I'm glad it works.

[KhemAryal]

Hi @XanderBakker 

I did not notice this yesterday but Its showing different than expected on the count. there are actually total of 3187 features (not 1000). and there should be 2 counts 'need cleaning', What do you think?

KhemAryal_0-1611936112848.png

[XanderBakker]

Hi @KhemAryal ,

The symbology is probably limited to reading 1000 features for performance reasons. Do you need the correct statistics for the entire layer?

[KhemAryal]

Yes I need to reflect all the features in the layer with the symbology. Otherwise I have to create more fields and individually insert domains - cleaning needed or not needed