New Crystal Reports 2008 user here and I have a question about summing up results in a report. I'm not sure if I'm going about this the right way, so any advice is appreciated.

In my report there are about a dozen conditions that a client might have. I'm using variations of this formula (@condition) to show when they do (this result appears on the report):

if{label}="condition"
and{result}="Yes"
then"Y"

I have variations of this formula (@conditioncount) going on to try to give a number to the results:

if{@condition}="Y"
then ToNumber(1)

Then in the page footer I'm using a running total field that summarizes the @conditioncount using a sum.

The problem I'm running into is that when the report pulls, say, 5 clients with two same results the running total field tells me the total is 66 for this result. I noticed at the bottom of the screen that "Records" is indicating that there's way more records than are actually displaying, but I'm not suppressing any results so I don't know why this number would be higher.

Any ideas?

Excellent- works like a charm! Thanks so much!