spudmcc
asked on
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_Informatio n.Net Sales Total})-{Draw_Information. Net Sales Total})=0
then 0
else ({Draw_Information.Net Sales Total})/{Draw_Information. Net Sales Total}-(Previous({Draw_Inf ormation.N et Sales Total}))*100
spudmcc
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_Informatio
then 0
else ({Draw_Information.Net Sales Total})/{Draw_Information.
spudmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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)
spudmcc (Andy)
ASKER
If (Previous({Draw_Informatio
then 0
else ((Previous({Draw_Informati