I am trying to get stats for our physicians for the month. These are clinic visits where the patient ID doesn't change from one visit to the next. So, I created a unique ID to count patient visits using their account ID and the month, day and year of service. That way it is different for every month, day and year. However, I also only want patient's whose total charges for the service date are > 0. Otherwise it will count dates where charges were entered and backed out.
So currently my unique id is this: (patient id plus month plus day plus year)
I want it to also say "where "sum of price" > 0. When I use the word "where" or "when" it gives me an error. Anyone know what the crystal syntax would be for this?