jeudi 14 mars 2019

Nested If Statements SSRS Expression

Building a report and changing colour based on some variables. If it is a Break Semester then make the colour "Gainsboro". If attendance is less than 0.4 as well as not being null then make the colour "#ffc7ce"

I'm totally confused as to why this code won't run, it seems simple enough.

=IIF(fields!Break_Semester <> "Break Semester"
    ,IIF(len(Fields!Attendance.Value) <> 0 and Fields!Attendance.Value < 0.4 
        ,"#ffc7ce"
    ,"Gainsboro")
,"Gainsboro")

The code works when running this:

=IIF(len(Fields!Attendance.Value) <> 0 and Fields!Attendance.Value < 0.4 
    ,"#ffc7ce"
,"Gainsboro")

So I'm not sure why the nesting screws it up.

Any pointers?

Aucun commentaire:

Enregistrer un commentaire