Home Forums Reporting Services SSRS 2014 How can I form an IIF in my Matrix report in SSRS 2014? See message body. RE: How can I form an IIF in my Matrix report in SSRS 2014? See message body.

  • 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.