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!

Looks wrong. Summaries of summaries and calcs. Hard to say without seeing what drives the other summaries and calcs.

DPH looks like it is using only a single Dialings record in the calc numerator when it should use an aggregate.

Might help if you can post a sample file.