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