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!

How to adjust CMS Negative Values = 0 ??

Status
Not open for further replies.

dclark10

IS-IT--Management
Sep 9, 2003
5
US
One of our custom calculations causes negative values periodically, which is fine and I know why this happens, however I'm trying to figure out how CMS can make these values = 0 when it is negative. This is the calculation they are using:

sum(ACWTIME) - (sum(ACDCALLS) * 2)

The reason we do this is because IC 5.6 places the agent in ACW after each call for a very short period of time (around 2 seconds).

Is there something we could do different in the calculation or 'where' statement that would make negative values equal 0?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top