Help with displaying the total verdict

[saran26]

I have a test verdict field in my table called testverdict.

The possible options are

pass
fail
or null

I want to have a counter , that counts the total number of pass and fail skipping all the nulls

pass -5
fail -2
null - 5

it should display 7, and i should be able to include it in a chart as well.

Is it possible , the field name is - clearquest.verdict
we are using crystal reports designer 11.0

Thanks
Saran

 

[lbass]

If the field is actually null, it will not contribute to the count.

-LB