expression builder help

[Pritesh_karma]

in a report ive designed, im trying to use the expression builder.
im hoping that what i can do is select a record. get a total count, a
count where it equals 1, a count where it equals 2.
for the total count, i use ==Count(PROCUREMENT!INSTITUTION_ID) as my
control source.
Im sure theres a way to get a count for records equal to 1 and records
equal to 2.

What would i have to put in the control source.
=(Count(PROCUREMENT![2A]=2)) i tried this, dosnt seem to work.

 

[Douglas J Steele]

=Sum(Abs(PROCUREMENT![2A]=2))

or

=Sum(IIf(PROCUREMENT![2A]=2,1,0))