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; } } }

Survey123 if statement calculation

ChristopherMask

Good Morning Community,

Again, I know this shouldn't be hard, but I can't get the calculation to work using an if statement. Could someone help with the name columns Two09 and Two09Calc. It currently has this for the calculation:

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

Also, I would like to add a condition for NumberFatalities >=1 to the if statement.

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

OFS - Firebook Reporting Tool.xlsx

Find more posts tagged with

Accepted answers

KClarkDev_GIS

I think the issue might be that you are trying to use a comparison operator ( >= ) on a string ( '300' ). What is the field type of ${FinalFireAcreQuantity}? If it's a number type, try removing the quotes around 300 and see if that works.

All comments

KClarkDev_GIS

@PavlovaVitale In a case like this, it should go in the Calculate column

PavlovaVitale

on what type of column do you put the if statements?

ChristopherMask

Goodness, that worked! Thanks for the response and have an excellent weekend!

Also, added more to the statement. if((${FinalFireAcreQuantity}>=300 or ${NumberFatalities} >=1), 'Yes','No')

Christopher

KClarkDev_GIS

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.