Counting String Values 2

[nerdlinger]

I need to count all the "Yes" values in a table and am using the following
Count({as.q1},"Yes&quot and keep receiving this error
The Summary / Running Total Field Could Not Be Created

Any idea what I am doing wrong...


Thanks

 

[kenhamady]

You got fooled by the 'condition' argument, which applys to making a grand total into a subtotal by specifying a group 'condition' (poor choice of words).

See my FAQ on common formulas. It includes 2 ways to do conditional totals like the one you need. Ken Hamady

http://www.kenhamady.com/

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