counting values

[lynn atkinson]

Hi
I am having a mental block at the end of the day.
I am wanting to count the responses in a questionnaire. I have a field
called 'attending' and the possible values are 'valuable' 'okay' or 'not
valuable'. I want to report on how many thought that attending was 'valuable'
how many thought it was'okay' and so on. In my report I have used
=Count([attending]="valuable")
as the expression, but it just counts the number of entries not how many say
"valuable"
What expression do I use to return the required results?

 

[Duane Hookom]

Count() will simply count all values. False is a value as is True.

You should try:
=Sum(Abs([attending]="valuable"))
generically:
=Sum(Abs(-- your expression here --))