substitute the (0) with "" when totaling.

[Frank]

The totaling is working fine but I am getting (0) if there is no "First".
How can I substitute the (0) for "".

=Sum(iif(Fields!Shift_Worked.Value="First",1,0))

Thank you for any suggestions offered

Frank

 

[Marshall Barton]

The totaling is working fine but I am getting (0) if there is no "First".
How can I substitute the (0) for "".

=Sum(iif(Fields!Shift_Worked.Value="First",1,0))

If you don't want to display a 0 result, then set the text
box's Format property to something like:
#;;""