nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

If "and" statement not working as expected

WilderNiss1

I have a simple if statement (it's actually part of a much larger if statement, but this is the part giving me issues) that I can't figure out and I'm hoping to get some help on.

The issue I'm having is that the result always returns "hh", even when I select "vehicle" and "unk" or "no". In that situation I am hoping for a result of "vv", since the other selections shouldn't be possible when "vehicle" is not selected for the field ${human_loss_category_new_nest}. Any thoughts? I'm sure it's probably just syntax but I can't figure it out. Thank you!!

if((${failure_category_new_nest} = "human" and (${human_loss_category_new_nest} = "eggs taken" or "eggs trampled" or "eggs destroyed") and ${deliberate_new_nest} = "yes"), "vz",
if((${failure_category_new_nest} = "human" and (${human_loss_category_new_nest} = "eggs taken" or "eggs trampled" or "eggs destroyed") and (${deliberate_new_nest} = "unk" or "no")), "hh",

if((${failure_category_new_nest} = "human" and ${human_loss_category_new_nest} = "vehicle" and (${deliberate_new_nest} = "unk" or ${deliberate_new_nest} ="no")), "vv")))

Find more posts tagged with

Accepted answers

AdamMesser1

@WilderNiss1 Your OR statements are mixed. In your first lines you use (${deliberate_new_nest} = "unk" or "no") which is a list of values separated by or . The last lines use (${deliberate_new_nest} = "unk" or ${deliberate_new_nest} ="no"). I think S123 may require the later approach where each value is preceded by the @{field}= .

All comments

WilderNiss1

Thanks @AdamMesser1 - adding the @{field}= everywhere in the syntax that had an "or" did the trick!

AdamMesser1

@WilderNiss1 Yes, that is my understanding. I don't have time to look into it/test right now but my approach to nested functions that are being difficult is stepwise testing. If you create a series of test S123 fields you can verify each set of choices at the most nested level first. Once that works, then copy it up to the next level in a new field, and repeat until the top or most outermost level is reached. Usually, these types of syntax errors have a simple solution, but looking at them all makes them hard to decipher.

WilderNiss1

@AdamMesser1 - Is that true for the AND statements too, or just the OR statements? Right now it appears that the AND statement works, but I could be missing something.

AdamMesser1

WilderNiss1

I should clarify, the result always results in "hh" if I select "no" or "unk". If there is a yes, it returns "vz" which is good

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.