hbadministrator
Posting Yak Master
120 Posts |
Posted - 06/19/2013 : 15:09:09
|
I have a single field I want to color code.
If less than 0 then red if 1-44% then black if 45 and greater Green.
The field name is GP it is a value like .45 but I formatted it to ##.##%. So maybe that is my issue.
Any way this is what I thought I should do.
=IIf(Fields!GP.Value <0, "Red",IIf(Fields!GP.Value > 1 < 44, "Black", IIf(Fields!GP.Value >45, "Green")))
Or if I was to use the report field it would be =IIf(ReportItems("GP1".Value < 0, "Red",IIf(eportItems("GP1".Value > 1 < 44, "Black", IIf(eportItems("GP1".Value > 45, "Green"))) |
|
visakh16
Very Important crosS Applying yaK Herder
India
52326 Posts |
Posted - 06/20/2013 : 01:10:14
|
i think this should work fine =IIf(val(Fields!GP.Value) <0, "Red",IIf(val(Fields!GP.Value) <= 0.44, "Black", "Green"))
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
|
 |
|