Hello

I have a chart on a report that shows value of sales on the Y Axis. The value can be a positive or negative amount. I want the Label colour for the Y Axis to show negative amounts in Red and Positive in black.

My problem is i can not seem to find the correct syntax within the expression.

eg if i was doing the same thing to based on a field i would use IIF(Fields!FieldName.value <0, "RED"< "BLACK"). How do i write the expression to say if the Y Axis label shows less than zero to make the colour Red?

Can any one help me on this? Let me know if you need any more info and i can post what you need.

Thanks in advance

Dave Munro

=IIF(Fields!FieldName.value < 0, "RED", "BLACK")

lookout for typo's