J
Joe
I have a query where I've returned two values: Total # HR Review and
then # HR Review. I then have a field where I'm figuring a percent
with the formula: FormatPercent([# HR Review]/[Total # HR Review],0)
My problem is that when there is a 0 in both fields, then the result =
#Error. How do I write the formula so that it returns 0 instead of
#Error?
then # HR Review. I then have a field where I'm figuring a percent
with the formula: FormatPercent([# HR Review]/[Total # HR Review],0)
My problem is that when there is a 0 in both fields, then the result =
#Error. How do I write the formula so that it returns 0 instead of
#Error?