Trouble Calculating Averages in a Report

[Ray Stantz]

Hello all,

I have a report where i'm trying to get an average from three fields using:

=Avg([Profile Accuracy]+[RA Accuracy]+[RC Accuracy])

However, it keeps returning the total. Any ideas?

I.e. 3.4+2.0+4.6 to give me an average of 3.33 but what i get is 10.0

Thanks in advance.

Ray

 

[boblarson]

You don't use Avg that way. Avg will average the result of a Field over the entire column.

You should just be using:

=(Nz([Profile Accuracy],0)+Nz([RA Accuracy],0)+Nz([RC Accuracy],0))/3

 

[boblarson]

By the way, I put the NZ in there for you to deal with possible NULLS otherwise it would not work right.

 

[Ray Stantz]

boblarson Thank you! It worked perfectly.

Ray