Divide by zero error encountered

[Sjac]

I keep getting this 'Divide by zero error encountered' error message, can someone please help me correct this?

Increase =

CASE

WHEN sp.AccessLevel = 1

THEN NULL

WHEN ps.LastAnnualizedPayRate = 0

THEN 0

WHEN ps.LastAnnualizingFactor = 0

THEN 0

ELSE CONVERT(decimal(12,2), ROUND((ps.PayRate - (ps.LastAnnualizedPayRate /

ps.AnnualizingFactor)), 2))

END,

[June7]

Correct it by not dividing by zero. You show division by ps.AnnualizingFactor. Where does this value come from? Why would it be 0?

[Sjac]

That worked, thanks for your help!!