I'm trying to build a report that measures the rate a clinic exceeds standard visit resolution.
For each Clinic I need a count of patients with 1 or more visits exceeding standard or @Yes_No = "Yes"
Group 1 = Clinic Name
Group 2 = PatID
Detail fields = PatID, VisitID, Visit Start Date, Visit End Date
A patient can have several visits
Here are my formulas
I placed a RunningTotal Formula in the detail section but I still can't get the total by CLinic
Can anyone help?