There's several ways to solve this, Charlece. One way is just to keep the count yourself of non-duplicated patients. If you just need a total total (rather than key totals), do a footnote AL START "0"^/COUNT, then a footnote AL D to call a macro "count". The macro would look like: [EMAIL PROTECTED]'=/COUNTED 1+/COUNT^/COUNT,@patient^/COUNTED;1}
Then create a computed field with VAL=/COUNT and print that in your report trailer line. /COUNT will just be incremented for each unique patient. There are probably easier ways that the True NPR Masters will describe, but this will work for you as long as you're processing in patient sequence. Let me know if you have questions, thanks! Gary Hall Clinical Applications Specialist Estes Park Medical Center Information Systems Department 970-577-4443 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Grubbs Charlece Sent: Monday, November 13, 2006 8:10 AM To: Meditech L List Subject: [MEDITECH-L] SCH Patient Count-CMG I am using in the detail segment - sch.appointment and for index file - sch.appt.patient.index The problem is I'm trying to get a patient count but if the patient has more than one appointment it's counting the patient multiple times. Can someone help with this? Charlece M. Grubbs Application Developer - IT/S HCA Healthcare PAS - Atlanta 678.421.7715 This email and any files transmitted with it may contain PRIVILEGED or CONFIDENTIAL information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and that any use, dissemination, distribution, forwarding, printing, or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed. The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender of this communication immediately. ====================================== All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
