Division by zero

Hi All!

I continue to get a division by zero error even though the syntax check says "no errors".  I've been starting at it and just can't seem to find out how to fix this issue:

Here is the formula:

If (Previous({Draw_Information.Net Sales Total})-{Draw_Information.Net Sales Total})=0
then 0
else ({Draw_Information.Net Sales Total})/{Draw_Information.Net Sales Total}-(Previous({Draw_Information.Net Sales Total}))*100

spudmcc
spudmccAsked:
Who is Participating?
 
JayConverseConnect With a Mentor Commented:
You should be checking the denominator:

If ({Draw_Information.Net Sales Total})=0
then 0
else ((Previous({Draw_Information.Net Sales Total})-{Draw_Information.Net Sales Total})/{Draw_Information.Net Sales Total})*100
0
 
spudmccAuthor Commented:
Sorry--pasted wrong formula

If (Previous({Draw_Information.Net Sales Total})-{Draw_Information.Net Sales Total})=0
then 0
else ((Previous({Draw_Information.Net Sales Total})-{Draw_Information.Net Sales Total})/{Draw_Information.Net Sales Total})*100
0
 
spudmccAuthor Commented:
Thank you so much for the 2nd set of eyes.  It was driving me crazy.  I so very much appreciate your quick response, knowledge and time.  

spudmcc (Andy)
0
All Courses

From novice to tech pro — start learning today.