Count where value ="Yes" 1

[JSMITH242B]

Hi Group,
I have a field called "Disabled" in the underlying data source for my crystal report. The data holds yes or no values depending on whether the person is disabled or not.

I need to create a formula to count the number of disabled people i.e where the value is equal to yes. I have the following formula:
count ({VM6_csv.Disabled},{VM6_csv.Disabled}="Yes&quot
but I get the error message:The summary/running total could not be created.
What is the correct syntax to count the number of records where a value is equal to something you want to specify?
Any help much appreciated.

TIA
Jackie

 

[synapsevampire]

The simplest means is to use a Running Total, and in the Evaluate->Use a formula place something like:

{table.yesnofield} = "Yes"

Or you can create a formula:

if {table.yesnofield} = "Yes" then
1
else
0

Place the field in the details, right click->insert summary->sum.

Now remove it from the details.

-k

 

[lyanch]

You can just sum the field: sum({table.yesnofield}) for the count of yes's. Yes=1.

Lisa

 

[synapsevampire]

Lisa: True, but I generally apply the KISS principle to this sort of thing.

 

[bdreed35]

You can also use the iif function to make it slightly simpler:

iif({table.yesnofield} = "Yes",1,0)

It work the same as the if statement above.

-Brian