Hi,

I am using Crystal 2008. I am getting the Division by Zero error message, which points to my following formula:

If {@fSUMVaccine-Participation}/DistinctCount ({EMPLOYEE.FLDID2}, {EMPLOYEE.FLDLOC})*100 = 0 then 0 else {@fSUMVaccine-Participation}/DistinctCount ({EMPLOYEE.FLDID2}, {EMPLOYEE.FLDLOC})*100

What do I need to change in this formula to get it to work? Thanks!

Use Below, so when denominator is zero then 0 else calculate:
If DistinctCount ({EMPLOYEE.FLDID2}, {EMPLOYEE.FLDLOC} = 0 then 0 else
{@fSUMVaccine-Participation}/DistinctCount ({EMPLOYEE.FLDID2}, {EMPLOYEE.FLDLOC})*100