I am working on a report for quality measures for physicians.
I can usually do group SUM and COUNT calculations without problems – but for percentages I have problems sometimes (like now) with what text boxes to put where.
I need to report the percentage for the physician practice without using AVG.
The report is GROUPED on the Physician Practice Name, then the Date Representing the Quarter, then the Quality Measure. It then lists the physician, numerator/denominator –like:
Physician Practice Name
CY13 Q2
Colorectal Screening
Physician Numerator Denominator Percentage
Dr Smith 710 2295 31%
Dr Jones 693 1172 59%
Dr Pepper 1488 4656 32%
Etc…
Physician Practice Totals 2891 8123 ????
How would I get the “Physician Practice Total” percentage?
Thank you,
Vicky
Report Calculation for Percentage
-
- StarLounger
- Posts: 96
- Joined: 11 Feb 2010, 21:59
- Location: Ohio
-
- Administrator
- Posts: 78556
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Report Calculation for Percentage
Let's say the text boxes with the sum of the Numerator and of the Denominator in the Physician Practice group footer are named txtNumeratorTotal and txtDenominatorTotal, respectively. For the percentage text box, set the Control Source to
=[txtNumeratorTotal]/[txtDenominatorTotal]
and format this text box as a percentage with 0 decimal places.
=[txtNumeratorTotal]/[txtDenominatorTotal]
and format this text box as a percentage with 0 decimal places.
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 96
- Joined: 11 Feb 2010, 21:59
- Location: Ohio
Re: Report Calculation for Percentage
That's outstanding - can't believe it was that easy.
I was using variations of =Sum([txtNumeratorTotal]/[txtDenominatorTotal]).
I will be sure to remember not to use Sum!
Thanks so much!
I was using variations of =Sum([txtNumeratorTotal]/[txtDenominatorTotal]).
I will be sure to remember not to use Sum!
Thanks so much!