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!

Occupancy 1

Status
Not open for further replies.

billysonnie

Technical User
Mar 15, 2010
1
US
hey im trying to build a colum data where the agents occupancy is calculated i have Agent.dur_inc + Agent.dur_inc_wrap and i want to divide by agent.dur_signed_on
and ideas how to build it thanks
 
Possibly like this:

if (
Sum ({AgentProductivity_Element.DUR_INC}, {AgentProductivity_Element.EXT_NUM}) +
Sum ({AgentProductivity_Element.DUR_SIGNON}, {AgentProductivity_Element.EXT_NUM})
) = 0 then 0
else
(
Sum ({AgentProductivity_Element.DUR_INC}, {AgentProductivity_Element.EXT_NUM})) %
(
Sum ({AgentProductivity_Element.DUR_INC}, {AgentProductivity_Element.EXT_NUM}) +
Sum ({AgentProductivity_Element.DUR_OUT}, {AgentProductivity_Element.EXT_NUM}) +
Sum ({AgentProductivity_Element.DUR_SIGNON}, {AgentProductivity_Element.EXT_NUM})
)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top