IF for color condition

[Luisanabria]

Hi All,

Hope someone can help me please:

I have  in my script this but in my table is not working as l want:

LOAD

"Sector (cp)"                   as [Sector CP Contacto]

if((Len("Sector (cp)"))>=5,1,0)             as [Flag Sector CP DIR Contacto]

and.. in one table i want to put this colors if the field is null (red) if not (green)

if([Flag Sector CP DIR Contacto]=0,rgb(235,0,0),rgb(231,239,220))

l have same conditional for "TIPO CONTACTO" and "ORIGEN CONTACTO" but for "Sector CP" is not working ok

if in my table l put the "[Flag Sector CP DIR Contacto]" works ok, the condition but when use my field Sector CP with same condition no

Hope someone can help me thanks

[Kayleigh_Milewski]

I don't believe you can change the color of a null field unfortunately. What you could do is change the field to something like if(isNull(x), 0, x). That would replace all of the null values with 0 (or whatever value makes the most sense in your case). The background color would then be able to be changed.