October 26, 2012 at 10:55 am
I am trying to use this code, keep getting error. Can somone please help.
=SWITCH(IIF(Fields!summary_name.Value LIKE 'CH_*' AND Fields!MY.value < 0.9850), 'RED','BLACK')
Thank You,
October 26, 2012 at 3:51 pm
Why are you using a switch and an IIF? Seems like you should be able to get by with just the IIF.
October 26, 2012 at 4:21 pm
=Iif(Left(Fields!summary_name.Value, 3) = "CH_" AND Fields!MY.value < 0.9850), "RED","BLACK")
October 29, 2012 at 10:23 am
Thank you for your reply, but the above statement still doesnt format the way it suppose to be.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply