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.

  • December 3, 2015 at 6:01 pm

    #1843960

    =IIF(Fields!Category.Value = "Actual" AND Fields!Periodic.Value <5,"red","black")

    Maybe with

    =IIF(Fields!Category.Value < Fields!Periodic.Value ,"red","black")

    ?

    If actual is less than budgeted I would think that is a good thing. I would highlight it red if it were say >10% over budget or something similar. Just my two cents.

    ----------------------------------------------------