Divide By zero Error

Question

Hi i am trying to do the following calculation but I get an error satating 'divide by error encountered'

SELECT Customer1, QtyRefunded, Year, Month, QtySales, CAST(SUM(QtyRefunded) * 1000000 / SUM(QtySales) AS DECIMAL(9, 2)) AS PPM
FROM dbo.[Refunds&ShippedJoin]
GROUP BY Customer1, QtyRefunded, Year, Month, QtySales

I pressume it is becuase I am dividing a number by 0, however I don't know how to ressolve this error.
Thank you for your help in advance.

Sreejesh SP · Answer

hi Emry DECLARE VALUE VARCHAR(50) SET VALUE=SELECT SUM(QtySales) AS DECIMAL(9 2) FROM dbo.[Refunds&ShippedJoin] IF(VALUE)>0) BEGIN SELECT Customer1 QtyRefunded Year Month QtySales CAST(SUM(QtyRefunded) * 1000000 / SUM(QtySales) AS DECIMAL(9 2)) AS PPM FROM dbo.[Refunds&ShippedJoin] GROUP BY Customer1 QtyRefunded Year Month QtySales END TRY THIS CODE REGARDS SREEJESH