sum a distinctcount formula

[tc3596]

CR version = 8
problem: I have 2 groups. The inner group has a distinct count total. Then I created a formula to multiply that value by an integer. Now, I want to total(sum) that formula's value by my outer group.
sum(distinctcount(.......)) won't work. Any ideas?

 

[kenhamady]

Crystal doesn't allow you to do a summary of a summary field. But you can sum these if you use a variable to make a running total formula. See the FAQ on running totals in the general forum, and use the "3 formula" technique described there. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)