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!