I work in a hospital outpatient clinic.
Fields are:
Clinic name:
Doctor name:
Appointment status: <-- this could be ARR, CXL, BMP, NOS, PEN, or RSC
DUR: <-- duration in minutes (such as 20, 40, 60, 90, 120)
My provider footer counts the number of occurances for each appointment status. I achieved this by the following:
=Sum(IIf([AS]="ARR",1,0))
=Sum(IIf([AS]="CXL",1,0))
=Sum(IIf([AS]="BMP",1,0))
=Sum(IIf([AS]="PEN",1,0))
=Sum(IIf([AS]="RSC",1,0))
I would now like to total the duration for each appointment status under each provider. To obtain the total duration for all appointment types, I would use =Sum([DUR])
How do I get the footer to only provide me the sum of the duration for only one appointment status? For example, I want to know the total number of minutes involved for all arrived (ARR) patients.
Fields are:
Clinic name:
Doctor name:
Appointment status: <-- this could be ARR, CXL, BMP, NOS, PEN, or RSC
DUR: <-- duration in minutes (such as 20, 40, 60, 90, 120)
My provider footer counts the number of occurances for each appointment status. I achieved this by the following:
=Sum(IIf([AS]="ARR",1,0))
=Sum(IIf([AS]="CXL",1,0))
=Sum(IIf([AS]="BMP",1,0))
=Sum(IIf([AS]="PEN",1,0))
=Sum(IIf([AS]="RSC",1,0))
I would now like to total the duration for each appointment status under each provider. To obtain the total duration for all appointment types, I would use =Sum([DUR])
How do I get the footer to only provide me the sum of the duration for only one appointment status? For example, I want to know the total number of minutes involved for all arrived (ARR) patients.
