GarethRoynon
Technical User
Hi,
Ive created a Call Profile Report from scratch which looks at multi dates from the daily table and multi skills. It all works fine and Im trying to get the totals to work. Ive created a new query for the totals and wanted to put an extra box with the totals at the top.
The ACD calls and ABA calls all total up fine but Im having a problem with the PERIOD1-9 totals. As its multi days and multi skills I cant figure the formula to total the figures under the period1 etc. I tried sum(period1) but of course this adds the secs up and comes up with 1:00 when the period is 0-5 and there were 12 lines to add up.
I hope this is making sense!
Ultimately, how can I add up the individual calls from multi days and skills under the 0-5 sec period.
So itd look like this>
Total Calls Handled 0-5 Secs From all skills and days input =
Thanks...
Ive created a Call Profile Report from scratch which looks at multi dates from the daily table and multi skills. It all works fine and Im trying to get the totals to work. Ive created a new query for the totals and wanted to put an extra box with the totals at the top.
The ACD calls and ABA calls all total up fine but Im having a problem with the PERIOD1-9 totals. As its multi days and multi skills I cant figure the formula to total the figures under the period1 etc. I tried sum(period1) but of course this adds the secs up and comes up with 1:00 when the period is 0-5 and there were 12 lines to add up.
I hope this is making sense!
Ultimately, how can I add up the individual calls from multi days and skills under the 0-5 sec period.
So itd look like this>
Total Calls Handled 0-5 Secs From all skills and days input =
Thanks...