Crystal Reports:
Divide by Zero Error
Check the divisor for Zero values in a division formula
If you have a formula with division like this…
{fielda} / {fieldb}
There may be a situation when your report will fail with a
divide by zero error. for zero to trap errors in the formula. Zero can be
divided by any number test {fielda}, you just need to test {fieldb}.
The formula above should be written as
If {fieldb} = 0 then 0 else {fielda} / {fieldb}
This article is copyrighted by
Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be
freely copied and distributed as long as the original copyright is
displayed and no modifications are made to this material. Extracts are
permitted. The names Crystal Reports and Seagate Info are trademarks owned
by Business Objects.
|
