Summing results of a formula that occurs at the group level

[mirror152]

I'm using CR 11.

I have a report that, in the details section, makes a list of client problems. For each problem, there should be a responsible staff. At the group level, I've got two running totals - one that counts the number of problems and another that counts the number of responsible staff. I've then got a formula that I've inserted at the group level that evaluates whether those two totals are equal. If they aren't it returns "N" (or 1, I've tried both). I'd then like to count the "N"'s.

There are a couple of problems. First, it won't let me write a formula that sums the number of "N"'s (or 1's). Second, when I tried to do a cross tab on the formula that generates the "N"'s, it calculates those formulas for the information that is in the details section. In other words, while there are about 4000 consumers, they have about 100,000 problems and what shows up in the cross tab is the 100,000.

So, how do I count group summaries?

 

[Turkbear]

Hi,
a step back, please:

Why running totals and not Counts ( using the Insert Summary function)?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[IdoMillet]

Crystal can't total totals.

You should use a variable for this. Increment it in a GF1 formula that checks the totals. Display the final result in a Report Footer formuala.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dgillz]

The formula:

If {YourField}="N" then 1 else 0

Can be summarized easily. Is there some reason this won't work?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[IdoMillet]

A simple 1 or 0 formula won't work because the required IF logic in this case depends on totals. This means that such a formula can't be totaled. Hence, the suggested variable incrementing approach.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com