Skip to Content
0
Former Member
Dec 01, 2008 at 09:52 PM

CR 8.5 - why would the report show data for all but a few records?

21 Views

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