This ticket is still open, any ideas?
=IIF(Fields!Category.Value = "Actual" AND Fields!Periodic.Value <5,"red","black") <---------This is works
So I compared to "budget" periodic value instead of the number 5 but to no avail though. See IIF below.
=IIF((Fields!CAT_ACTUAL_BUDGET.Value = "Actual" AND Fields!Periodic.Value) < (Fields!CAT_ACTUAL_BUDGET.Value = "BUDGET" AND Fields!Periodic.Value),"red","black")
It returns the values but not the conditional formatting.
Any ideas on how to make this work? See first comment box for question.