Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CMS CALL PROFILE MULTI SKILL MULTI DATE

Status
Not open for further replies.

GarethRoynon

Technical User
Jan 23, 2006
27
GB
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...
 
This sounds like a similar issue I had with starttime + intrvl in a multiskill interval report. As soon as a sum formula was used on this calcluation "sum(hsplit.STARTIME) + sum(hsplit.INTRVL)" the return value summed the actual start times and Interval times!

I got around this by using the formula "AVG(hsplit.STARTTIME) + AVG(hsplit.INTRVL)" This returned the correct interval time.

Maybe you can use "Avg(Period1)
 
Hey thanks for the response. ive just figured it though. It wasnt PERIOD1 it was ACDCALLS1 so when I put in Sum(ACDCALLS1) it brings it up. PERIOD1 is just the time definition so its all cool now.

Oh i love CMS reports!! mmmmmm
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top