topic Re: Survey123 if statement calculation in ArcGIS Survey123 Questions

Survey123 if statement calculation

ChristopherMask — Fri, 20 Oct 2023 14:33:25 GMT

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.

Re: Survey123 if statement calculation

Katie_Clark — Fri, 20 Oct 2023 15:24:22 GMT

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.

Re: Survey123 if statement calculation

ChristopherMask — Fri, 20 Oct 2023 17:07:41 GMT

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

Re: Survey123 if statement calculation

PavlovaVitale — Thu, 08 Feb 2024 23:13:34 GMT

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

Re: Survey123 if statement calculation

Katie_Clark — Fri, 09 Feb 2024 15:24:30 GMT

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