Colour expression

[JoseGarcia]

Hi, 
Could anyone help with  this colour expression?
Cannot figure-out the error.
Thanks a million!

if(EightD.Kx_Classification='K1S' and Date(EightD.D1_KPIDate+15) > today(),
RGB(220,50,35),
RGB(50,70,30)
,
if(EightD.Kx_Classification<>'K1S' and Date(EightD.D1_KPIDate+30) > today(),
RGB(220,50,35),
RGB(50,70,30)
)
)

[Or · Accepted solution]

That's not the correct syntax for an If() statement. You seem to have kept on going after the false condition (50,70,30).

Perhaps:

if(EightD.Kx_Classification='K1S' and Date(EightD.D1_KPIDate+15) > today(),
RGB(220,50,35),

if(EightD.Kx_Classification<>'K1S' and Date(EightD.D1_KPIDate+30) > today(),
RGB(220,50,35),
RGB(50,70,30)))

You could also just turn this into a single If() statement using an OR between the two condition sets.

[brunobertels]

Hi 

May be this 

if(EightD.Kx_Classification='K1S' and Date(EightD.D1_KPIDate+15) > today(),

RGB(220,50,35),

if(EightD.Kx_Classification<>'K1S' and Date(EightD.D1_KPIDate+30) > today(),

RGB(220,50,35),
RGB(50,70,30)
)
)

[JoseGarcia]

it worked nicely, thanks a million!