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: | ? |