getting an average on the "Count" in a report summary

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

I have a report where the data is grouped on "Date by Month". In the
footer, there is a summary that shows the number of records for the
month. There is also a sum for the total miles. I would like to get an
average of Miles per record for the month. I hope I have explained
what I would like to do sufficiently.

TIA for any help given.

Justin
 
Justin said:
I have a report where the data is grouped on "Date by Month". In the
footer, there is a summary that shows the number of records for the
month. There is also a sum for the total miles. I would like to get an
average of Miles per record for the month.
Click to expand...


I believe the average could be calulated with the
expression:

=[the sum text box] / [the count text box]
 
Justin said:
I have a report where the data is grouped on "Date by Month". In the
footer, there is a summary that shows the number of records for the
month. There is also a sum for the total miles. I would like to get an
average of Miles per record for the month.
Click to expand...

I believe the average could be calulated with the
expression:

        =[the sum text box] / [the count text box]
Click to expand...


Thanks. Worked like a charm.

Justin
 
Back
Top