Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 1 -

Author  Topic 

Fredforfree
Starting Member

49 Posts

Posted - 2009-07-23 : 14:01:09
Hello people

Please explain in simple terms for me what the 1 - is doing in this code.

Agent_Calls_Handled_Source_Internal / (1 - Percent_Agent_Calls_Abandoned_Internal)

fredforfree

Fred

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-07-23 : 14:04:48
It's in effect
Agent_Calls_Handled_Source_Internal /Percent_Agent_Calls_Handled_Internal.

Jim
Go to Top of Page

Fredforfree
Starting Member

49 Posts

Posted - 2009-07-23 : 14:07:29
Hi Jimf

if that is the case then why put it in the code at all?
Also if i remove it then I get a different result

Fred
Go to Top of Page

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-07-23 : 14:44:00
It's a strange metric. I don't know if the original intent is to back into the Number of Calls Handled, or Abandoned Internal versus Abandoned in queue. If you can't find out where the original numerator and denominator come from and divine intent from that, I think you better just ask the original programmer what his intent was.

Jim
Go to Top of Page
   

- Advertisement -