divison by zero 1

[Paul1981]

Hi,

I am currently using Crystal Reports XI and have created a report containing a formula which divides two formulas.

The problem is, if the formula's result to '0', then I get the following error message: "Division By Zero".

Is there away of geting around this? I understand you can not divide by '0', but I was wondering if you can ignore?

thanks

Paul

 

[hilfy]

I usually handle this with an If statement in the formula (Crystal syntax):

if {@BottomNumber} > 0 then
{@TopNumber} / {@BottomNumber}
else 0

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[synapsevampire]

You need a slightly different formula to be safe, and it's only the denominator that you need to check for:

if {@BottomNumber} <> 0 then
{@TopNumber} / {@BottomNumber}
else
0

A denominator could be a negative number, so checking for NOT zero is what you should use.

-k

 

[Shtinky]

Another way would be:

if {@BottomNumber} = 0 then 0
else
{@TopNumber}/{@BottomNumber}

 

[synapsevampire]

Right, Shtinky, you can switch THENs and ELSEs in any formula.

-k