Distinct count...but not really

[mmorala]

Hi,
I have a pretty complicated problem. I want to count calls made by a call center. They can have 3 outcomes: Completed, Left Message, and No Answer.

I want to count calls made to specific customers and track the outcomes, but no more than 3. For example, a rep calls customer XYZ 11 times last month. These were the results:
5 no answers
2 left messages
4 Completed
After the "no more than 3" rule, the revised results are:
3 no answers
2 left messages
3 Completed
Giving a grand total of 8 results because I don't want to count after the first 3 similar results to customer XYZ. Is there a way to do this in Crystal?

Thanks,
Michael

 

[crystalreporting]

There's a number of ways to do this one (running totals etc.) depending on how you are summarizing your data. One option would be to replace your existing distinct count summary fields with formulas e.g.

if DistinctCount ({table.no_calls}, {table.call_type}) <= 3
then
DistinctCount ({table.no_calls}, {table.call_type})
else
3

Assuming you are grouping by call type - you'd also need to subsitute your field/tables names and make sure it matches the group.

Peter Shirley

http://www.linkcorp.com