https://community.esri.com/t5/arcgis-survey123-questions/calculation-not-working/m-p/1389085#M55141 <P>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:&nbsp;if(selected(${crime},'crime'),1, 0)</P><P>&nbsp;</P><P>OR change the name in the choices sheet to 'crime observed'</P> Thu, 29 Feb 2024 20:33:08 GMT dolson_farmington 2024-02-29T20:33:08Z https://community.esri.com/t5/arcgis-survey123-questions/calculation-not-working/m-p/1389013#M55135 <P>Still looking for the assistance of people smarter than I with this survey. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>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.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="alyssajhnsn_0-1709231671705.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/96347i4D15B94058D7D0B6/image-size/medium?v=v2&amp;px=400" role="button" title="alyssajhnsn_0-1709231671705.png" alt="alyssajhnsn_0-1709231671705.png" /></span></P><P>In Survey123, the value shows as 0 when the option for crimeobserved is selected.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="alyssajhnsn_1-1709231793071.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/96348i7BCF3479F0836C82/image-size/medium?v=v2&amp;px=400" role="button" title="alyssajhnsn_1-1709231793071.png" alt="alyssajhnsn_1-1709231793071.png" /></span></P><P>The XLSForm is attached.</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 29 Feb 2024 18:40:24 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculation-not-working/m-p/1389013#M55135 alyssajhnsn 2024-02-29T18:40:24Z https://community.esri.com/t5/arcgis-survey123-questions/calculation-not-working/m-p/1389085#M55141 <P>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:&nbsp;if(selected(${crime},'crime'),1, 0)</P><P>&nbsp;</P><P>OR change the name in the choices sheet to 'crime observed'</P> Thu, 29 Feb 2024 20:33:08 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculation-not-working/m-p/1389085#M55141 dolson_farmington 2024-02-29T20:33:08Z https://community.esri.com/t5/arcgis-survey123-questions/calculation-not-working/m-p/1389349#M55152 <P>Definitely this. 'crimeobserved' isn't a choice in the list, so it will always return 0.&nbsp;&nbsp;</P> Fri, 01 Mar 2024 09:15:27 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculation-not-working/m-p/1389349#M55152 TylerGraham2 2024-03-01T09:15:27Z