Survey Calculation Formula Returns A Dependency Error.

[Marc_Patti]

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!

[jcarlson · Accepted solution]

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?

[Marc_Patti]

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