topic Survey Calculation Formula Returns A Dependency Error. in ArcGIS Survey123 Questions

Survey Calculation Formula Returns A Dependency Error.

Marc_Patti — Wed, 17 Jul 2024 12:32:03 GMT

I’m trying to make a change to an existing survey. Because no default value was set when the survey was created, most records either have a value of “Yes” or “Null.” I’m trying to make a calculation formula that sets a record’s answer to “No” if a null value, but Survey123 keeps telling me I’m creating a dependency cycle (see screenshot). Can anyone tell me where I’m going wrong with the calculation formula below?

if(${survey_status} = '', 'No', '')

Thanks so much!

Re: Survey Calculation Formula Returns A Dependency Error.

jcarlson — Wed, 17 Jul 2024 14:13:07 GMT

Generally, you can't reference a field in its own calculation. Why not just run a field calculation against the whole table to convert the Nulls to No?

Re: Survey Calculation Formula Returns A Dependency Error.

Marc_Patti — Wed, 17 Jul 2024 20:54:56 GMT

Yep, that worked. Guess I was just overthinking this one. Thanks, Josh!