Creating a percent of total in a grouping level on a report

[kidkosmo]

Hi gang,

I'm in a bit of a pickle trying to figure out a way to do this. I
have a report based of "qryTeamMemberReport". This report has
criteria for a date range and a specific team member. On the report I
have two grouping levels. The first level is TeamMemberName. The
second is a grouping level for "Business Unit" to determine how many
tickets that team member has closed for each BU. In the
TeamMemberName footer, I have a text box to calculate the % of tickets
this team member closed for the entire group by using the formula
"Count([TeamMemberName])/DCount("[ID]","qryStaffComparison")" in which
qryStaffComparison contains records for everyone on the team.

My dilemma is that in the BU grouping which contains the total number
of tickets this specific team member has closed, we'd like to see the
percentage of tickets closed for that specific BU. In this regard, I
can't figure out if or how to use the DCount function to calculate the
number of tickets closed for that specific BU. Is there any other way
to accomplish this task on a report?

I hope this all makes sense. Any help would be sincerely
appreciated.

Thanks!!!

 

[ntc]

you might try first putting that total ticket count onto the report footer as
a stand alone subreport's text box (in the long run you can make it not
visible if appropriate)

add an unbound textbox in the BU footer

then in the onformat event for that footer put in your calc:

BU count/Total ticket count

the syntax for calling that total ticket count is probably something like
me.SubReportName.Report!textboxname

the caveat is that I'm not sure if the footer info is available to the BU
footer when the form loads - - so there may be better advice to come
along.....

 

[Beetle]

Put a hidden calculated control (text box) in the BU group *header*
(i.e. txtGroupTicketsClosed) and then use that text box as part of
your calculation for another text box to display the percentage like;

=txtGroupTicketsClosed/txtTotalTickets