https://community.esri.com/t5/arcgis-survey123-questions/survey123-summary-report-calculation/m-p/1158604#M41688 <P>Hi there,</P><P>Trying to figure out how to display value in the summary report: <STRONG># of retailers not checked</STRONG> section below.</P><P>I have <STRONG>#of total retailers</STRONG> and <STRONG># of retailers checked</STRONG> working. How can I put the right syntax to subtract #<STRONG> of retailers checked</STRONG> from <STRONG># of total retailers</STRONG> to get <STRONG># of retailers not checked</STRONG>?</P><P><FONT color="#3366FF"><STRONG># of retailers not checked =&nbsp; (# of total retailers) - (# of retailers checked)</STRONG></FONT></P><TABLE width="720"><TBODY><TR><TD width="252"><P><STRONG># of total retailers</STRONG>:</P></TD><TD width="107"><P><SPAN>${Compliance_Check_Copy|stats:"max,totalbusiness"}</SPAN></P></TD><TD width="199"><P><STRONG># of retailers&nbsp; checked</STRONG>:</P></TD><TD width="162"><P>${Compliance_Check_Copy|where:"type='tobacco' "|stats:"count,objectid"}</P></TD></TR><TR><TD width="252"><P><STRONG># of retailers not checked</STRONG>:</P></TD><TD width="468"><P><STRONG>?</STRONG></P></TD></TR></TBODY></TABLE> Mon, 28 Mar 2022 21:44:31 GMT Heena1 2022-03-28T21:44:31Z https://community.esri.com/t5/arcgis-survey123-questions/survey123-summary-report-calculation/m-p/1158604#M41688 <P>Hi there,</P><P>Trying to figure out how to display value in the summary report: <STRONG># of retailers not checked</STRONG> section below.</P><P>I have <STRONG>#of total retailers</STRONG> and <STRONG># of retailers checked</STRONG> working. How can I put the right syntax to subtract #<STRONG> of retailers checked</STRONG> from <STRONG># of total retailers</STRONG> to get <STRONG># of retailers not checked</STRONG>?</P><P><FONT color="#3366FF"><STRONG># of retailers not checked =&nbsp; (# of total retailers) - (# of retailers checked)</STRONG></FONT></P><TABLE width="720"><TBODY><TR><TD width="252"><P><STRONG># of total retailers</STRONG>:</P></TD><TD width="107"><P><SPAN>${Compliance_Check_Copy|stats:"max,totalbusiness"}</SPAN></P></TD><TD width="199"><P><STRONG># of retailers&nbsp; checked</STRONG>:</P></TD><TD width="162"><P>${Compliance_Check_Copy|where:"type='tobacco' "|stats:"count,objectid"}</P></TD></TR><TR><TD width="252"><P><STRONG># of retailers not checked</STRONG>:</P></TD><TD width="468"><P><STRONG>?</STRONG></P></TD></TR></TBODY></TABLE> Mon, 28 Mar 2022 21:44:31 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-summary-report-calculation/m-p/1158604#M41688 Heena1 2022-03-28T21:44:31Z