Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
Below logic in expression fix the issue.
Logic: if(sum(sales)>0,sum(sales)), which replace zero's with null.
Thanks..
can you provide some sample data
Thats because CK, MC and DI are no the same name that the one in the field. Check for lower cases or the value.
Is not it because you only have value in the first two columns?
Simulate a case where all columns are not null.
Hi,
It is because of the first row is null.
Let me know how to get this.
Thanks..
Hi,
Below logic in expression fix the issue.
Logic: if(sum(sales)>0,sum(sales)), which replace zero's with null.
Thanks..