Count 1

[savok]

Lets say I have a field on the report which is either YES or NO, and I have 20 NO and 2 YES, I know how to get a total count which is 22, but how can i get a count of only the YES fields, which is 2?


thanks

 

[kenhamady]

This is a conditional total which can be done 2 ways.
See FAQ #1B, and read the section on conditional totals.
Ken Hamady

http://www.kenhamady.com/

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

 

[savok]

thanks!

 

[savok]

Another question, where do i find the FAQ?

 

[savok]

I made a fomula

If {table.late} = 'NO' then
1
else
0


but all this does is only count the first row?

 

[savok]

Never mind found the problem, I didnt do the Sum

thanks