divide by zero 1

[LloydDobler]

Hi all, getting a divide by zero error, even with a CASE statement. Am I missing something?

CASE WHEN SUM(QuantityProduced)= 0 THEN 0 ELSE SUM((QuantityProduced - scrap) / QuantityProduced) end AS QUALITY

fields QuantityProduced and Scrap are both numeric. Using Query analyzer and SQL 2K.



"I don't want to sell anything, buy anything or process anything as a career. I don't want to sell anything bought or processed... or buy anything sold or processed... or process anything sold, bought or processed... or repair anything sold, bought or processed. You know, as a career, I don't want to do that."

 

[cmartin75]

Try this:

SUM(CASE QuantityProduced WHEN 0 THEN 0 ELSE ((QuantityProduced - scrap) / QuantityProduced)) end AS QUALITY

 

[cmartin75]

the end must be within parenthesis


SUM(CASE QuantityProduced WHEN 0 THEN 0 ELSE ((QuantityProduced - scrap) / QuantityProduced) end) AS QUALITY

 

[LloydDobler]

Giddy up cmartin, thanks. Knew it was gonna be something stoooopid I did.

"I don't want to sell anything, buy anything or process anything as a career. I don't want to sell anything bought or processed... or buy anything sold or processed... or process anything sold, bought or processed... or repair anything sold, bought or processed. You know, as a career, I don't want to do that."