I need to highlight (fill) a field based on when the numeric value is greater than 7.00.
I tried the following expression in the text box properties > "Fill"
=IIF(SUM(Fields!Dispatched_to_at_Scene.Value, "DataSet1") >7.00, "yellow", "no color")
However, it highlights the entire column regardless of the value...
Thanks in advance.