AnsweredAssumed Answered

Report Summary Averages

Question asked by sadhu-x on Aug 1, 2018
Latest reply on Aug 1, 2018 by philmodjunk

I'm struggling with getting some of these summary calculations to work for a report. First, definitions:

 

DPH =  Dials per hour

CPH = Completes per hour

DPC = Dials per complete

 

I'm doing sort by sub summary by study (PR2, etc), above and below, and by date.

 

I'm sorting by study and date.

 

The information by date looks okay, except for the DPH column, where the numbers are slightly off. If you divide 31/5, for example, you get 32.29, but FM is showing me 32.20. The subtotals for counts look okay (dials, hours, and completes), but calculating the averages for DPH, CPH and DPC is not working and I'm not sure why. Any help would be appreciated. Thanks!

 

report_screenshot.PNG

 

table_calc.PNG

 

relationships.PNG

Outcomes