This switch statement also worked:

=Switch(Sum(Fields!Delta.Value) <= -1, "Red", Sum(Fields!Delta.Value) >= 1, "Green", Sum(Fields!Delta.Value) = 0, "Black")

Thank you to everyone for the help and ideas!

This statement worked:

=IIF(Sum(Fields!Delta.Value) < 0, "Red", IIF(Sum(Fields!Delta.Value) > 0, "Green", IIF(Sum(Fields!Delta.Value) = 0, "Black", "Black")))

I think I know what may be causing this issue but not sure how to fix it.

The stored procedure returns multiple rows of data that are summed in the report...

1) Have you tried putting the [value = 0, "Black"] part in the front of the IIf statement?

yes - this had no affect

2) Does the text box containing the expression...

The data type in the text box properties is set to "Number" with decimal places set to 0

adding the INT(Field!Delta.Value) = 0 had no affect.

The data is coming back from...