Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
divide by zero
- Thread starter zippyhm
- Start date
synapsevampire
Programmer
Paste in the formula if the following doesn't resolve.
Divide by zero errors are common, but I've not experienced a bug that causes them, rather an oversight in my code.
If you're going to do division, always do something like:
If not(isnull({MyTable.Factor})) <> 0
and {MyTable.Factor} <> 0
then
{MyTable.Amount}/{MyTable.MyField}
else
0
The not(isnull()) may be overkill.
-k kai@informeddatadecisions.com
Divide by zero errors are common, but I've not experienced a bug that causes them, rather an oversight in my code.
If you're going to do division, always do something like:
If not(isnull({MyTable.Factor})) <> 0
and {MyTable.Factor} <> 0
then
{MyTable.Amount}/{MyTable.MyField}
else
0
The not(isnull()) may be overkill.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question