Evading Divide by 0 errors

[Pete Rogers]

Hi,

I'm creating a sales report for my company, and one of the things I need to do is work out the growth. To do this I've added in a calculation.

(a.[YTD Net sales]-[Previous YTD Net sales])*100)/a.[Previous YTD Net sales])

However, Some customers will have 0 sales either this YTD or last year.

How can I get around this so if either YTD Net Sales or previous YTD equals 0 then just return a 0.

A colleague has told me just to throw a Nullif in front of the calc but thats not working.


I come from a strong excel background, so I would use Iferror(Calc,0) in excel, is there anything similar to this in SQL?