Background colour

[nareshthavidishetty]

Hi,

I have used the below code to get the background colour,but for few codes the background colour is not came .

Code:

=if(Category='CS',rgb(196,191,191),

if(Category='CK',rgb(196,191,191),

if(Category='MC',rgb(196,191,191),

if(Category='VS',rgb(196,191,191),

if(Category='DI',rgb(196,191,191)

)))))

Thanks..

[neelamsaroha157]

can you provide some sample data

[joseduque]

Thats because CK, MC and DI are no the same name that the one in the field. Check for lower cases or the value.

[Anonymous]

Is not it because you only have value in the first two columns?

[Anonymous]

Simulate a case where all columns are not null.

[nareshthavidishetty]

Hi,

It is because of the first row is null.

Let me know how to get this.

Thanks..

[nareshthavidishetty · Accepted solution]

Hi,

Below logic in expression fix the issue.

Logic: if(sum(sales)>0,sum(sales)), which replace zero's with null.

Thanks..