SSRS background expression and null values issues

Question

I have a report in this format I would like to do this kind of background on SSRS dynamically, I thought to do the following condition: = Iif (CInt (Fields! MoisBC.Value)> = CInt (Fields! MoisFact.Value), "Yellow", "PaleTurquoise") it works but the condition does not apply to null values, here is the results someone already experience this problem? thank you.

Is your expected result null cells be colored in PaleTurquoise? Avoid post an answer if it is not the solution to your problem, to provide feedback to anyone use comments instead. — alejandro zuleta

p2k p2k · Accepted Answer · 2016-09-25T15:46:29

Try by adding extra IIF condition to check NULL.

IIF(
   IIF(ISNOTHING(Fields! MoisBC.Value), 0, Fields! MoisBC.Value) >=
   IIF(ISNOTHING(Fields! MoisFact.Value), 0, Fields! MoisFact.Value)
, "Yellow"
, "PaleTurquoise")

SSRS background expression and null values issues

1 Answers