Percent Calculations

[Bill Trainer]

I have a summary report that is providing a sum of items processed for each
wroker. then by team, location and report footer. What I need to also provide
is:
% of each work within a team by the team footer
% of each team by location footer
% of each team by grand total footer

Is this done in the query, or can this be done in the report, if so how?

I know how this can be done in Excel by not sure how to accomplish this in
Access since all the footers have the same formula.

 

[Marshall Barton]

I have a summary report that is providing a sum of items processed for each
wroker. then by team, location and report footer. What I need to also provide
is:
% of each work within a team by the team footer
% of each team by location footer
% of each team by grand total footer

Is this done in the query, or can this be done in the report, if so how?

I know how this can be done in Excel by not sure how to accomplish this in
Access since all the footers have the same formula.

The percent for each worker can be displayed in the detail
section by using an expression like
=workertotalfield / txtTeamTotal
where txtTeamTotal is a text box in the team group header
section using the expression
=Sum(workertotalfield)

The team percentage text box in the team footer section
would use an expression like
=Sum(workertotalfield) / txtLocationTotal
where txtLocationTotal is a text box in the location group
header with the expression
=Sum(workertotalfield)

Another team percentage text box in the team footer section
would use an expression like
=Sum(workertotalfield) / txtGrandTotal
where txtGrandTotal is a text box in the report header with
the expression
=Sum(workertotalfield)
If you meant you wanted a location percentage it would be
the same expressions in the Location group footer.