Calculation not working

Question

Still looking for the assistance of people smarter than I with this survey. 🙂

I got most of the calculations working, but there's one that just won't work. (I'm sure it's for a dumb reason). When selected, it does not calculate a value like it's supposed to. The bind is set to integer.

In Survey123, the value shows as 0 when the option for crimeobserved is selected.

The XLSForm is attached.

Encampment Site Assessment.xlsx

TylerGraham2 · Answer

Definitely this. 'crimeobserved' isn't a choice in the list, so it will always return 0.

dolson_farmington · Answer

I think it is because you have CrimeObserved named differently in your "choices" sheet. There, it is just listed as "crime", so in your calculation, you'd have to write: if(selected(${crime},'crime'),1, 0)

OR change the name in the choices sheet to 'crime observed'