"NAN" and "INFINITY".....

HELP!I have a report that is calculating properly 99% of the time but a small amount of the data is coming up "NAN" and "INFINITY" Any suggestions? This is baffeling me!!

You may want to read the following blog article: http://blogs.msdn.com/bwelcker/archive/2006/09/26/End-of-Amnesia-_2800_Avoiding-Divide-By-Zero-Errors_2900_.aspx

Besides the solutions described in the article, you can also write custom code functions using IF-ELSE-END IF VB statements to avoid division by zero.

-- Robert

|||Thanks! :)