Adding Color

Hi everyone, I am trying to get this to work, but I know its all screwed up. I want Fields!PERCENT_OF_STD.Value to display red if its less than 100% or greater than 200%. If its neither, then just be plain black. This is what I came up with:

=(Fields!PERCENT_OF_STD.Value >= 200%, "RED", (Fields!PERCENT_OF_STD.Value <= 99%, "RED"))

Thanks,

Abz

abz_26 wrote:

Hi everyone, I am trying to get this to work, but I know its all screwed up. I want Fields!PERCENT_OF_STD.Value to display red if its less than 100% or greater than 200%. If its neither, then just be plain black. This is what I came up with:

=(Fields!PERCENT_OF_STD.Value >= 200%, "RED", (Fields!PERCENT_OF_STD.Value <= 99%, "RED"))

Thanks,

Abz

Try this:

=(Fields!PERCENT_OF_STD.Value >= 200% OR Fields!PERCENT_OF_STD.Value <= 99% , "RED", "BLACK")

|||

Aren't you forgetting the function name? Also, I suspect the percentage values come back as decimal 1 or 2 and is then formatted as a %.

Such a comparisson does not make sense x = 200% because 200% is the formatted value. Try this:

If your percentages come back as 1 or 2 then:

=Iif(Fields!PERCENT_OF_STD.Value >= 2 OR Fields!PERCENT_OF_STD.Value < 1 , "RED", "BLACK")

If your percenatges come back as the actual umber i.e. 100 or 200 then:

=Iif(Fields!PERCENT_OF_STD.Value >= 200 OR Fields!PERCENT_OF_STD.Value < 100 , "RED", "BLACK")