Hi I have an expression which is not doing what I would like, and I wondered if anyone could help me with it: =iif(sum(Fields!Number_Free.Value)=0,"lime",iif(sum(Fields!Number_Free.Value)>=0,"orange","red")) Basically if the sum of the field equals 0 then lime, if greater 0 then orange, but it doesnt seem to be working. I am not too fussed about using red, I would be quite happy with the lime and orange. Can anyone advise? Thanks

hi try this one =iif(sum(Fields!Number_Free.Value)=0,"lime",iif(sum(Fields!Number_Free.Value)>0,"orange","red")) Hope this will help you !!! Sanjeewan

Hi, =IIF(Sum(Fields!Number_Free.Value) < 0,"Red","Green") this is for if you want these two text in output if you want background Red or Green then follow these steps 1. Go to textbox properties 2. Click on Backgroud Color and place this expression 3=IIF(Sum(Fields!Number_Free.Value )< 0,"Red","Green") Hope this will help you !!! Sanjeewan

Hi, Yes thank you. This works for part of the report, but I have an expression to sum positive values =SUM(iif(Fields!Number_Free.Value < 0,0,Fields!Number_Free.Value)) which I would like to say if the number is less than 0 then red, otherwise green - is this possible? Thanks :-)

Hi, =IIF(Sum(Fields!Number_Free.Value) < 0,"Red","Green") this is for you want these two rext in output if you want background Red or Green then follow these steps 1. Go to textbox properties 2. Click on Backgroud Color and place this expression 3=IIF(Sum(Fields!Number_Free.Value )< 0,"Red","Green") Hope this will help you !!! Sanjeewan