Count or If formula 1

[zenzabar]

This should be simple but I continue to get errors.

Using Crystal XI

My data looks like this (very simplistic)

47 48 49
Yes NO Yes
NA YES YES
Yes NO NA
NO NO YES
YES YES NA


What I need is a formula that will count all YES, NA and NO for each 47, 48 and 49

So I should see under for 47 - 3 Yes, 1 - NA, 1 - NO

Help Please!

 

[raja2008]

Hello!
Iam asuming that you are groupng on the 47,48,49.
use running totals ,create three running totals :
in the "evluate" instead of "for each record" select the fomula and
write a formula like table.answer = "yes",
for the next one table.answer="no" and t
he sameway table.answer="NA"

"reset" set to "on change of group.

Hope this helps.