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 statement

GaryBowles1

I am trying to calculate a yes or no answer for a field using the formula below.

if((string-length(${inbox_flag})=5,"yes" and string-length(${leak_tagno})>0,"yes"), 'yes', 'no')

I keep receiving invalid result and have been banging my head against the wall all afternoon. What am I doing wrong?

Thanks,

--gary

Encontre mais publicações marcadas com

Accepted answers

KClarkDev_GIS

Hi Gary,

This worked for me:

if((string-length(${inbox_flag})=5 and string-length(${leak_tagno}) > 0), 'yes', 'no')

You had extra "yes" statements in there that weren't needed. Hope it makes sense!

All comments

ChristopherMask

Good Morning Katherine,

Wondered if you would give this a quick look.

The name columns Two09 and Two09Calc. It currently has this for the calculation:

if((${FinalFireAcreQuantity}>=300 and $NumberFatalities} >=1), 'Yes','No')

If statement is true, then Two09 = Yes, if not Two09 = No.

Christopher

OFS - Firebook Reporting Tool.xlsx

GaryBowles1

That worked.

Thanks!!

--gary

KClarkDev_GIS

Hi Gary,

This worked for me:

if((string-length(${inbox_flag})=5 and string-length(${leak_tagno}) > 0), 'yes', 'no')

You had extra "yes" statements in there that weren't needed. Hope it makes sense!

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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