dplowman
asked on
SSRS Subtotal to exlude rows with a blank field
I'll do my best to explain my situation. I have an ssrs report that calculations utilization per associate. Utilization is the total time spent on inbound and outbound calls divided by hours worked. My issue is that an associate may have hours worked, but may not have any inbound or outbound calls that day. So I do not want to include these hours in the subtotal utilization field. The code and screenshot are below. For instance, Grace Eliasen subtotal shoudl be 154%, not 77%.
=(sum(Fields!Inbound_Connect.Value)+sum(Fields!outbound_Connect.Value)+sum(Fields!Inbound_Waiting.Value)+sum(Fields!outbound_Waiting.Value)+sum(Fields!Inbound_ACW.Value)+sum(Fields!outbound_ACW.Value)+sum(Fields!Inbound_Deassign.Value)+sum(Fields!outbound_Deassign.Value))/(sum(Fields!hoursworked.Value)*60*60)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
=iif(Fields!Inbound_Calls.