Calculation Formula

[Jonathan212]

I have a report that grouped on surgeon name and weekdaydescription (e.g., Mon, Tue...) to arrive at minutes used per day per surgeon

The report derives minutes used per case and sums up the total for each day. I need to build in 10 minutes for each case to account for turnover (to clean) the room.

Example:

OR1 (Monday)
40 minute case 10 minute turnover time
20 minute case 10 minute turnover time
30 minutes case (last case of day) 0 minutes turnover

I need to calculate total minutes used (e.g., 90 minutes)to turnover time (e.g. 20 minutes) to arrive at an adjusted minutes used. Therefore, for Monday, I would like to see total minutes used as 110 minutes.

I first tried using a formula that derives total number of cases done in a room (less one case) times 10 minutes. And then doing another formula that adds the procedures minutes used to the turnover time to arrive at an adjusted minutes total.

Here was my formula:
DistinctCount ({pcmCase.caseNumber}, {pcmSurgeons.name})*10

My problem is that the turnover time formula works when all days of the week are totalled, but my specific days of the week are incorrect. The individaul days of the week are showing turnover time based on all cases done by the surgeon and not just cases done on a Monday or Tuesday, etc.

Obiously, I am missing some argument somewhere and am stumped.

I am using CR10. Help, please. Jonathan

 

[lbass]

For the specific days, you should use a different formula:

DistinctCount ({pcmCase.caseNumber}, {table.date})*10

This should work as long as your date group is nested within the surgeon group.

-LB

 

[Jonathan212]

Thanks LB, it works. Most appreciated !!!!!