Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Divide by zero error

Status
Not open for further replies.

acessn

Programmer
Feb 16, 2005
71
NO
Hi.

Using CR9.0, reporting from MSSQL database.

I've made a report consisting of quite a few formulas which calculates percent.

i.e
numerator / denominator

Sometimes the denominator is 0. I'm aware that I can do

If denominator <> 0 then
numerator / denominator

,but I don't want to go into each formula to do that (Lazy, I know, but there are hundreds of formulas...).
Is there somehow a global setting of some sort that can ignore this error and just output zero, instead of failing the entire report?

Thanks,

Bjorn
 
That's what I suspected, but thanks for clarifying.

Regards,

Bjorn
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top