deep_patel1
SSC Journeyman
Points: 75
More actions
October 26, 2012 at 10:55 am
#393472
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,
TheGreenShepherd
SSCertifiable
Points: 6979
October 26, 2012 at 3:51 pm
#1553430
Why are you using a switch and an IIF? Seems like you should be able to get by with just the IIF.
Ray M
SSC-Insane
Points: 21093
October 26, 2012 at 4:21 pm
#1553440
=Iif(Left(Fields!summary_name.Value, 3) = "CH_" AND Fields!MY.value < 0.9850), "RED","BLACK")
October 29, 2012 at 10:23 am
#1553794
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