Link to home
Start Free TrialLog in
Avatar of John Mahoney
John Mahoney

asked on

Count If in Crystal Reports

I have a report in Crystal that displays the count of days between Today and when a client last had a service. It's very simple formula
TODAY() - {v_rpt_ClientActivities_Prg_Epi_LDOS.LDOS}  I call this function LDOS

The formula returns a number or the count of days between these two dates. I also have an alert setup that shows this number in red if the client has not shown up for 30 or more days. I used the highlighter to do this and just set it to highlight this number in RED if the number  => 30.
 
 Now I want to count the number of these clients. I want to count the number of clients that meet this criteria but I am running into issues.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of John Mahoney
John Mahoney

ASKER

thank you