I am trying to count using a set of multiple criteria and would appreciate any help available. I work at a county jail and have a report showing who has come to jail on what charges by date. The booking_id is unique to a person, but can be used multiple times for each arrest by date. For example John Doe, booking id 123, may have come to jail 3 times this year. If I distinctcount booking id's then it would only count John Doe one time.
Does anyone know how I would count the record if it is a unique combination of date arrested and booking id? In excel, I could use sumproduct, but that function doesn't exist in the crystal reports environment.
IP Logged