Divide by zero error encountered 1

soutener · Sep 20, 2006

Divide by zero error encountered."

i get above error when i try this code...

Code:

UPDATE SET AVGSL=NETDOL/NETQTY

my data types are decimal
i'm trying to figure out the average selling price

thanks

gmmastros · Sep 20, 2006

This can only occur if NETQTY is zero. You have a couple ways to deal with this.

Code:

Update Table
Set    AVGSL= Case When NetQty = 0
                   Then 0
                   Else NETDOL/NETQTY
                   End

or

Code:

Update Table
Set    AVGSL= NETDOL/NETQTY
Where  NetQty <> 0

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

soutener · Sep 20, 2006

brilliant!
thanks