substitute the (0) with "" when totaling.

  • Thread starter Thread starter Frank
  • Start date Start date
F

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
 
Frank said:
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))
Click to expand...


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