Add one more Value

How can I add one more Value besides "Hireback", I need to add "Hireback3".
I tried using (OR) and could not get it to work.
=iif(Sum(iif(Fields!Workday_Type.Value="Hireback",1,0)) > 0,
Sum(iif(Fields!Workday_Type.Value="Hireback",1,0)),"")
Thank you
FrankOn Jan 11, 9:51 am, Frank <Fr...@.discussions.microsoft.com> wrote:
> How can I add one more Value besides "Hireback", I need to add "Hireback3".
> I tried using (OR) and could not get it to work.
> =iif(Sum(iif(Fields!Workday_Type.Value="Hireback",1,0)) > 0,
> Sum(iif(Fields!Workday_Type.Value="Hireback",1,0)),"")
> Thank you
> Frank
This expression should work.
=switch(Sum(iif(Fields!Workday_Type.Value="Hireback",1,0)) > 0,
Sum(iif(Fields!Workday_Type.Value="Hireback",1,0)), Sum(iif(Fields!
Workday_Type.Value="Hireback3",1,0)) > 0, Sum(iif(Fields!
Workday_Type.Value="Hireback3",1,0)), true, "")
Regards,
Enrique Martinez
Sr. Software Consultant