Don't want to show any zeros

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=iif(
Sum(iif(Fields!Shift_Worked.Value="First",1,0)) > 0,
Sum(iif(Fields!Shift_Worked.Value="First",1,0)),
""
)
"Frank" wrote:
> 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
>|||Jimbo,
Thank you very much, it works great.
"Jimbo" wrote:
> =iif(
> Sum(iif(Fields!Shift_Worked.Value="First",1,0)) > 0,
> Sum(iif(Fields!Shift_Worked.Value="First",1,0)),
> ""
> )
>
> "Frank" wrote:
> > 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
> >