Skip to Main Content

Divide by zero error encountered

User_AEU5MFeb 18 2022 — edited Feb 18 2022

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,

This post has been answered by Frank Kulash on Feb 18 2022
Jump to Answer
Comments
Post Details
Added on Feb 18 2022
3 comments
59 views