Skip to Content
0
Former Member
Jun 20, 2014 at 03:04 AM

Help I stuck on "This field cannot be summarized"

508 Views

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

Code: @HourstoResolve := DateDiff ("h",{@StartDateTime},{@Sh_OrderDateTime} )



Code: @Yes_No :=
If
(ToText({@Sh_OrderDateTime}) = "" or
ISNULL({@HourstoResolve}) or
ISNULL({@StartDateTime}) or
{@HourstoResolve} > 2)
then
"Yes"
else
"No"



Code: @ExceedStandard :=
If
{@Yes_No} = "Yes"
Then
1
Else
0


I placed a RunningTotal Formula in the detail section but I still can't get the total by CLinic


Can anyone help?

Thanks
Steve