Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formula question

I need help creating a formula for this situation.  Whenever someone "mistakenly" labels a patient as the wrong kind of visit, the database still shows these records.  (I cannot change the database).  See example:

DatePatientVisit Type
2/1/2015John DoeNew Patient
2/1/2015John DoeEstablished Patient

How can I create a formula that will count "John Doe" as 1 visit?  Perhaps renaming this visit as "Unknown Type", so we can separate these in the report?

I have a Crystal Report showing the number of new patient visits/month and the number of established patients/month.

I already have a formula field grouping the patient name and date, so I can get an accurate count, no matter how many visits a patient has in a month.

Thanks for any help.

Former Member

Sorry about that - a lot of the folks who post here are not IT folks.

Try this.... Go to my website -  There's an "email me" link there that you can use to email the report to me.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question