Can you post the actual calculation used to compute patients per hour?
Count ( Clarity Census Report::recordID ) / hours worked res::hours worked
table name translations from my initial post
Clarity Census Report ~ PatientTable
hours worked res ~ HoursTable
I could be wrong but I think it should be:
Count ( Clarity Census Report::recordID ) / Sum ( hours worked res::hours worked )
as I think you have two related records with different hours worked values in your related table once you broaden the date values to include two months instead of one.
actually you might be right--I have a similar setup with attendings (my original example is for residents) and that pts/hour calc does use SUM
Yes--that fixed it. Thanks as usual for your help!