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_Pr g_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.
TODAY() - {v_rpt_ClientActivities_Pr
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER