Division by zero

[Dukester0122]

Tried several times to get rid of the 'division by zero' error but nothing seemed to work. My original formula was:
Sum ({AVSOPHDR.DEPRECVD}, {@territory}) / Sum ({AVSOPHDR.DOCAMNT}, {@territory}) * 100

then tried this

if Sum ({AVSOPHDR.DEPRECVD}, {@territory}) / Sum ({AVSOPHDR.DOCAMNT}, {@territory}) * 100 > 0

then Sum ({AVSOPHDR.DEPRECVD}, {@territory}) / Sum ({AVSOPHDR.DOCAMNT}, {@territory}) * 100

else 0

still was getting the error

 

[xxing]

Try This:

if Sum ({AVSOPHDR.DOCAMNT}, {@territory}) = 0 then
0
else
Sum ({AVSOPHDR.DEPRECVD}, {@territory}) / Sum ({AVSOPHDR.DOCAMNT}, {@territory}) * 100