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:
|2/1/2015||John Doe||New Patient|
|2/1/2015||John Doe||Established 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.