Hi all,

I am currently working on a report, showing the number of new invoices added to the system. i want to show this on client level. I created a formula saying:
DISTINCTCount ({client.client_id}, {client.client_name}).

The cases are loaded on mass actions. The dates of these actions can change, there are days that this is always loaded.

I want to show a count of the unique client id's. This looked fine at first. But when we started testing this, the numbers didn't at up. When I ran the reports on the dates the cases were loaded, they wer correct. But when I ran this formula on the date range, I missed 25 records. I found out that this was because some clients had invoices on more than 1 date. But if this is the case, I want to count them on both dates.

I've been thinking about creating a sort of loop, counting the new invoices on each specific date, and then adding them up. But I'm not sure how to do this. Is there anyone who can help me with this? Or who has a different solution?

Thanks in advance

Gerben

hi Ryan,

Thanks for your reply. If a client has more then 1 invoice on the same day, it should count as only one. But if the client has invoices on more then one date, he should be counted for onces for every date. Do I make sense?

KR

Gerben

Group by Client_Name;

Create a formula, we'll call it @day;

Edited by rkrowland - 28 Mar 2012 at 2:12am

Crystal can only count the records that are returned, unless you manually enter the previous total each time you run the report the only way to return the total is to run the report for all invoices without any date parameters.