Calculating percentage from grouped report

  • Thread starter Thread starter Leanne
  • Start date Start date
L

Leanne

My report shows jobs attended grouped by the engineer who went. My report has
parameter values so i can search between the dates i want. From this i would
like in the group footer to be able to calculate what percentage of the total
records shown in the report were completed by each engineer.

I want to be able to divide the total records by the total records in the
group

any help will be much appreciated
 
Leanne said:
My report shows jobs attended grouped by the engineer who went. My report has
parameter values so i can search between the dates i want. From this i would
like in the group footer to be able to calculate what percentage of the total
records shown in the report were completed by each engineer.

I want to be able to divide the total records by the total records in the
group
Click to expand...


To use the grand total for the whole report, put a text box
(named txtgrandTotal) in the report's header section and set
its expression to =Count(*)

If you have no other reason to use the report header
section, make it invisible.

Then your group footer text box can display the percentage
by using the expression =Count(*) / txtgrandTotal
 
Thank you for that.

Do you know how i could use this percentage that is calculated to create a
pie chart?
 
Leanne said:
Do you know how i could use this percentage that is calculated to create a
pie chart?
Click to expand...


Best to start a new thread when you have a different
question. I have not had to create a chart in Access in 15
years, so I would just be stumbling around if I tried to
answer it.
 
Back
Top