topic Re: Conditional if statement: Null in expression in ArcGIS Survey123 Questions

Conditional if statement: Null in expression

Anonymous User — Thu, 14 Jun 2018 19:02:27 GMT

Hi all,

I'm trying to get some conditional if statements to work and I'm receiving an error that there is a NULL in the expression: if(${SARP_SCORE},1,'No Barrier',if((${SARP_SCORE},< 1) and (${SARP_SCORE},>=0.8),'Insignificant Barrier',if((${SARP_SCORE},< 0.8) and (${SARP_SCORE},>=0.6),'Minor Barrier',if((${SARP_SCORE},< 0.6) and (${SARP_SCORE},>=0.4),'Moderate Barrier',if((${SARP_SCORE}, <0.4 ) and (${SARP_SCORE},>=0.2),'Significant Barrier',if((${SARP_SCORE},< 0.2) and (${SARP_SCORE},>=0),'Severe Barrier','Not Scored'))))))

Any insight?

Thank you!

Re: Conditional if statement: Null in expression

JoeBorgione — Thu, 14 Jun 2018 19:30:08 GMT

I think it means that one of the fields you are querying has a <Null> value in it.

Re: Conditional if statement: Null in expression

Anonymous User — Fri, 15 Jun 2018 15:28:42 GMT

Thanks Joe. Do you mean one of the fields has no calculation? It looks like all have somethign in them, there are no NULLs

Re: Conditional if statement: Null in expression

JoeBorgione — Sun, 12 Dec 2021 08:34:54 GMT

That's what I was thinking, yes. But if that's not the case, take a look at the nests of if statements you have. It's really easy to miss a paren here or there in this style of scripting. I know my eyes go crossed in no time! Give me

if some_condition:
  do_something
elif some_other_condtion:
  do_something_different
else:
  do_something_altogether_different‍‍‍‍‍‍

And I'm a happy guy. What I've done in the past is write the nested conditions like what you are working with one at a time and try them, until I have the whole enchilada working.

see: How to use "if" and "then" on survey 123? Help with IIF statement /blogs/mapguymike/2017/02/21/nested-iifs-in-attribute-assistant

https://community.esri.com/message/635756-iif-function-in-dynamic-value-table