How can I summarize this formula OR how can I count this total?

[kate8]

Hi,

I have a report that checks if providers review the patient medications in certain visits.
The first group in the report is provider, second group is patient, and third group is visit. In each visit, the report compare the number of reviewed medications with the active medications that patient has, if these two numbers equal then count 1 for that provider. The total active medications(for example,@TotalaAMed) is calculated on patient level, the reviewed medicines are calculated on patient visit level, if total reviewed Med(@TotalRMed) equal to @TotalaAMed, then count 1 (I set it as @Completed)for this provider . For example, patient A has 5 active medicines, on the date 8/6/2013 visit, the doctor reviewed all 5 medicines, then this Doctor has 1 completed review. I need summarize the completed number for each provider, but that @Completed can’t be summarized in the way I am doing:
Provider: TotalCompleted# -?
PatientA: @TotalaAMed
Visit: @TotalRMed (if @TotalRMed =@TotalaAMed, then 1)
PatientB: @TotalaAMed
Visit: @TotalRMed (if @TotalRMed =@TotalaAMed, then 1)-@completed
Are there any suggestions/ideas for doing this right?
Thank you so much for any helps!!!

 

[Madawc]

You can't do a total based on more than one detail line.

What you can do is a field with a variable in the group footer, which could do the test and add (or not) to the variable.

If you're not already familiar with Crystal's totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[kate8]

Hi Madawc,

Thank you so much for your response!!
I just remember that I had similar situation before, and got helps from this forum. I create a running total and use formula in Evaluate, then insert running total to the Provider group footer. it is working.
Again, thank you!