Divide by 0 - error - help needed

[WillR7]

I have the following formula.

If (({August_2002_Data.MonthInt}*12)<>0 Or {August_2002_Data.Average} <> 0)
Then ((({August_2002_Data.MonthInt}/31*365)/{August_2002_Data.Average})*100)
Else 0

Now there are several instances in my report where both MonthInt & Average are 0, and i want to produce a blank or 0 result if this is the case....
The problem is, the report calculates OK and the formula editor says the formula ok...but on one of my report pages, when i try to select it, i get the following error message
&quot;Division by Zero&quot;
and get taken to the formula expert....
I can't see any difference between this group / page and all my others which are ok - can anyone help on this???

Cheers,

Will

 

[synapsevampire]

Change the OR to an AND, though you can just write:

If {August_2002_Data.Average} <> 0
Then
(({August_2002_Data.MonthInt}/31*365)/{August_2002_Data.Average})*100)
Else
0

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[WillR7]

Thanks k