2 Count from 1 field

[markj11]

I have a table column that could have either "a" or "b". How do I get a count of how many "a"'s? I know I am just overlooking something very obvious.
Thanks

 

[Sheco]

You could use Sum() instead of Count() like this:[tt]
=Sum(iif(Fields!MyLetter.Value = "a",1,0))[/tt]

 

[markj11]

Thanks.

 

[markj11]

That doesn't seem to work. I have 3 a's and 2 b's and my =Sum(iif(Fields!MyLetter.Value = "a",1,0)) & =Sum(iif(Fields!MyLetter.Value = "b",1,0)) both return 0.
Thanks

 

[markj11]

This is working, I had to RTRIM() the value.
Thanks