I am getting a "Overflow" error message when trying to run a report

[KingOf206]

No I am not. I am pretty sure that it is because I am finding the average of many values in the records and some of those values are going to be 0. I would like a way for it to account for those 0's without giving me an "overflow" error. How can I do this?

[orange]

Have you tried writing a few queries, or small procedure, to mock up the calculations being done in the report?
I'd try taking some records, lace it with some debug.prints and try to get the overflow error again.
Then repeat using step debugging-- I'm sure there is a division by 0 or some very small value resulting in overflow--but I'm just guessing. You have the data and the issue, so you can try some debugging and let us know how it goes.

[June7]

Average of zeros should return 0. No idea why Avg() is failing. If you want to provide db for analysis, follow instructions at bottom of my post.

[KingOf206]

Here is a copy of the database.

Let me know what else I could provide (I hope this works!)

[June7]

The overflow error is on Challenge Rate, not Challenged.

Remove the Percent formatting from the field in query to see the data as it truly is - very long decimal. I never do formatting in tables and queries, only on forms and reports. Record 10248 shows a #Num! error because of division by 0.

Why do GROUP BY since there really isn't any aggregation of data? Remove the grouping and ChallengeRate field and do this calc in report.

=Avg([Challenged]/IIf([Uploaded]=0,1,[Uploaded]))

[KingOf206]

Boom! Changing that formula in the report worked perfectly!! Thank you june7 !!!

The overflow error is on Challenge Rate, not Challenged.

Remove the Percent formatting from the field in query to see the data as it truly is - very long decimal. I never do formatting in tables and queries, only on forms and reports. Record 10248 shows a #Num! error because of division by 0.

Why do GROUP BY since there really isn't any aggregation of data? Remove the grouping and ChallengeRate field and do this calc in report.

=Avg([Challenged]/IIf([Uploaded]=0,1,[Uploaded]))