Occupancy 1

[billysonnie]

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

 

[gshadz37]

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})
)