QAD BI v3 – Tech Level 2 Certification - Part 1 > SQL – Preview > Divide by Zero Error – Solution: use CASE
  PPT
Divide by Zero Error – Solution: use CASE
 
Any coding being done that involves division should note this and the possibility that the divisor may end up being 0 anyway. Usually we use case statements so that if the divisor does = 0, then the results are set to 0.