CODEWITHSUNDEEP
reporting-servicesformattingconditional-statements
Nick Momin
Nick Momin

Reputation: 183

SSRS conditional formatting for blank value

I am trying to create conditional formatting for a table which contains percentages that range from 0 to 100%. I have successfully created conditional formatting that changes the font of all percentages < 50% to be white font with red background and anything higher than 50% to be black font color with white background.

This is the conditional formatting I am using for the background:

=IIF((Fields!Uptime.Value < 0.985) And (Fields!Uptime.Value >= 0.00), "Red", "Transparent")

My issue is that the conditional formatting is also formatting "blank" rows. So a blank row will show up as red square.

Instead, what I am trying to accomplish is:

PS, I am new to this website so please forgive me if I broke any rules on accident.

Thanks!!

Upvotes: 3

Views: 4666

Answers (1)

StevenWhite
StevenWhite

Reputation: 6034

You can check for blank values with the IsNothing function.

=IIf(IsNothing(Fields!Uptime.Value), "White", IIf((Fields!Uptime.Value < 0.985) And (Fields!Uptime.Value >= 0.00), "Red", "Transparent"))

Upvotes: 5

Related Questions