Hello,
I am trying to calculate an average of data that I have grouped twice and cannot figure out how to get Crystal to discard data in the details section that I do not want to use.
Here's the situation:
I am working with medical records. I have my data grouped by doctor. I use a table with every appointment for every patient, and since I only want one record per patient, I also group by patient record #. I keep all of my fields in the patient record # group header, giving me one row for each patient for each doctor.
I have then created formulas to score the fields using a point system. For instance, if a patient has a certain lab result, then the doctor gets one point.
I want to average these points per doctor per test field. Now, when I create summaries, I can get averages per doctor, though Crystal uses the appointment table with multiple records per patient instead of just one record per patient.
I would greatly appreciate any help I can get.
I am trying to calculate an average of data that I have grouped twice and cannot figure out how to get Crystal to discard data in the details section that I do not want to use.
Here's the situation:
I am working with medical records. I have my data grouped by doctor. I use a table with every appointment for every patient, and since I only want one record per patient, I also group by patient record #. I keep all of my fields in the patient record # group header, giving me one row for each patient for each doctor.
I have then created formulas to score the fields using a point system. For instance, if a patient has a certain lab result, then the doctor gets one point.
I want to average these points per doctor per test field. Now, when I create summaries, I can get averages per doctor, though Crystal uses the appointment table with multiple records per patient instead of just one record per patient.
I would greatly appreciate any help I can get.