In my report I have 4 Grouping Levels.
Group 1 - Agency
Group 2 - PatientName
Group 3 - CaseType
Group 4 - Status
In the report I am pulling in two date fields, a StartDate and an EndDate. I have also created a SQL calculation to give me the Number of days between the StartDate and EndDate.
Here is the issue I am facing, a Patient will have either a Medical or a Behavioral Health CaseType assigned to them for the visit. The issue is they can have both types of Cases on the same day. They can come in for a Medical reason and for a Behavioral Health related issue.
My issue is I need to count the number of distinct days and when I get the count on the Group Level for the Patient (Group2) my values get off due to visits with two case types in the same day. I need help getting this organized and set up right. Any help is appreciated.
Group 1 - Agency
Group 2 - PatientName
Group 3 - CaseType
Group 4 - Status
In the report I am pulling in two date fields, a StartDate and an EndDate. I have also created a SQL calculation to give me the Number of days between the StartDate and EndDate.
Here is the issue I am facing, a Patient will have either a Medical or a Behavioral Health CaseType assigned to them for the visit. The issue is they can have both types of Cases on the same day. They can come in for a Medical reason and for a Behavioral Health related issue.
My issue is I need to count the number of distinct days and when I get the count on the Group Level for the Patient (Group2) my values get off due to visits with two case types in the same day. I need help getting this organized and set up right. Any help is appreciated.