Survey123 Summary Report Calculation

240
0
03-28-2022 02:44 PM
Heena1
by
New Contributor III

Hi there,

Trying to figure out how to display value in the summary report: # of retailers not checked section below.

I have #of total retailers and # of retailers checked working. How can I put the right syntax to subtract # of retailers checked from # of total retailers to get # of retailers not checked?

# of retailers not checked =  (# of total retailers) - (# of retailers checked)

# of total retailers:

${Compliance_Check_Copy|stats:"max,totalbusiness"}

# of retailers  checked:

${Compliance_Check_Copy|where:"type='tobacco' "|stats:"count,objectid"}

# of retailers not checked:

?

0 Kudos
0 Replies