I have this formula that calculated the productivity for each employee in the report, but there are two employees that have HrsBill and HrsAct, but their Efficiency Percentage displays Zero.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Efficiency Percentage
if {CIT_RPT_SVSLSLBR;1.HrsBill}>0 then (Sum({CIT_RPT_SVSLSLBR;1.HrsBill}, {CIT_RPT_SVSLSLBR;1.EmpName}) / Sum({CIT_RPT_SVSLSLBR;1.HrsAct}, {CIT_RPT_SVSLSLBR;1.EmpName})) * 100
The report does a subtotal on EmpNameTyp and here it displays a "Efficiency Percentage" value in the subtotal. and
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
GroupTotal formula
(Sum({CIT_RPT_SVSLSLBR;1.HrsBill}, {CIT_RPT_SVSLSLBR;1.EmpNameTyp}) / Sum({CIT_RPT_SVSLSLBR;1.HrsAct}, {CIT_RPT_SVSLSLBR;1.EmpNameTyp})) * 100
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ReportTotal formula
(Sum({CIT_RPT_SVSLSLBR;1.HrsBill}) / Sum({CIT_RPT_SVSLSLBR;1.HrsAct})) * 100
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Can anyone see what I'm missing here?
Thanks
Kelvin