M
MichelleM via AccessMonster.com
I have created a report that has 2 sub reports in it. The report consists of
call handling data for 6 agents. One of the subreports contains a field that
averages the data among the 6 agents. When I run the sub report on its own,
the average field works fine. When I run the main report the average field
only uses the one agent. So if Jane Doe's data was 94%, then her "team
average" is also 94%. When I go to the next agent, John Smith's data was 87%,
and the "team average" listed there is also 87%. It should list the average
of all (e.g. 94+87/2=90.5%).
Thanks for any help!
call handling data for 6 agents. One of the subreports contains a field that
averages the data among the 6 agents. When I run the sub report on its own,
the average field works fine. When I run the main report the average field
only uses the one agent. So if Jane Doe's data was 94%, then her "team
average" is also 94%. When I go to the next agent, John Smith's data was 87%,
and the "team average" listed there is also 87%. It should list the average
of all (e.g. 94+87/2=90.5%).
Thanks for any help!