Hi,
I need to set a field to either red or black dependent on the aggregate value of 2 other fields. e.g.
if Fields!ActualCost2.Value < Fields!BudgetAmt.Value
then insert a 3rd field int the textbox Fields!Variance.Value and format it black
else insert the 3rd field Fields!Variance.Value and format it red
How should I do this?