Hi Daniel,

Am I missing something here? Why aren't you just using Call_Type_Skill_Group_Interval.CallsHandled?

Cheers,

Nathan Luk
From: Cisco Developer Community Forums <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Reply-To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Date: Wednesday, 10 October 2012 4:06 PM
To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Subject: New Message from Daniel Jebakumar in Contact Center Reporting (CCR) - Contact Center Reporting: Formula to calculate Calls Handled from Call_Type_Skill_Group_Interval tbl

Daniel Jebakumar has created a new message in the forum "Contact Center Reporting": -------------------------------------------------------------- Hi,

i need to show the calls handled in a report which uses Call_Type_Skill_Group_Interval table. Is there a formula to obtain the same.

Currently I use sum(isnull(CallsOfferedRouted,0)+isnull(CallsOfferedNotRouted,0)+isnull(CallsHandledNotRouted,0)). But the value doesn't match with those from other reports.

Can someone help me please. Thanks in advance.
--
To respond to this post, please click the following link: http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/7481518 or simply reply to this email.

Skill_Group_Interval.CallsOffered