backgroung color not works completely

[aheavy95]

Hi all,

In a report, I wanted to mark in red columns which dont get a CustomerName field.

I used this formula in the background color expression: 

if(IsNull([Primary Supplier Info]) or [Primary Supplier Info]='-',red(), )

for some reason it colors only a few of the rows, any idea why?

Thanks a lot 

Aon

[Frank_S · Accepted solution]

Hello 
Perhaps try this...

Make a copy of your measure expression and replace the 'else' with the background color.

In this example you are replacing 'Below Sales Target' with Yellow()  

Measure expression example
=if(sum(Sales)>10000,sum(Sales),'Below Sales Target')

Background Color Expression
=if(sum(Sales)>10000,sum(Sales),Yellow())