Loading

Divide By zero Error

Lynn Emery

13y2.6k

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sreejesh SP13y ago
Accepted 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
0