Hi Everyone

I'm trying to set up a generic set of calculations which will work out percentages

The problem i'm facing is, as many of you know, you cannot divide anything by 0 and sometimes there will be 0 in the results thus 0% however I do not know how to get Crystal to understand this without sending up an error message saying it cannot be divide 0

My formula has no errors until it's run and here it is

if ((Sum ({@Educo Availability Pass - Count})) / (Sum ({@Educo Availability - Count}))*100 = 0) then 0 else ((Sum ({@Educo Availability Pass - Count})) / (Sum ({@Educo Availability - Count})))*100

I hoped this would assume that if the first calculation = 0 then show 0 otherwise perform the calculation with those formula (it works if there are actually results so it's not a broken formula)

Does anyone know how to throw out a 0 if the result is a 0 divide?

Thanks in advance

DB

DBlank!

Thank you very much for the help

Works perfectly