3 or more conditions in color calculation turn everything black

[Anonymous]

Hello,

I have a chart that shows 4 different values for data.

I want each value being shown in a specific color, regardless of the filter I selected.

I used:

if(([Status])=Sold, lightGreen(),if(([Status])=Returned, LightRed(), if(([Status])=Reserved, LightBlue()))

It works when I have 2 if conditions but as soon as I add the 3rd one or even the 4th one, everything turns black.

I entered this in the background settings of the expression in the chart properties.

Anybody has any idea what is causing this?

[#2 · Accepted solution]

There are 3 if else condition but closed only 2

If possible, post sample document.

[robert_mika]

Try this:

if(([Status])='Sold', lightGreen(),if(([Status])='Returned', LightRed(), if(([Status])='Reserved', LightBlue())))

[avinashelite]

try like this:

if([Status]=Sold, lightGreen(),if([Status])=Returned, LightRed(), if([Status]=Reserved, LightBlue())) )

[Anonymous]

Duh!!! Thanks