divide by zero 2

[bgon1]

I have been trying to run a report where some of the denominators in a formula are zero ("cannot divide by zero"). The result is that the entire report is suspended. Is there a way to tell crystal to bypass the zero values or change them to another value ie. 1? Thanks for suggestions.

 

[lbass]

Add an introductory clause to each formula like:

if {table.denominatorvalue} <> 0 then //intro clause
{table.numeratorvalue}/{table.denominatorvalue} //original formula

-LB

 

[Durango122]

hi
(if {table.denominatorvalue} = 0
or
isnull({table.denominatorvalue})
then
0
else
{table.numeratorvalue}/{table.denominatorvalue}

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[lbass]

Note that if you need to do a null check, it should occur first in the formula, as in:

if isnull({table.denominatorvalue}) or
{table.denominatorvalue} = 0 then
0 else
{table.numeratorvalue}/{table.denominatorvalue}

-LB