IF color condition

[Luisanabria]

hi all

i have in my script this: 

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

so next i have table and here is where i want to use the IF color condition

this is my IF in my table

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

i dont have that "-" those are Null, l have exactly same in "AREA GENERA CONTACTO" and "TIPO CONTACTO"

why there works good, but for this "SectorCP" no?  only the green color works good but red no

[MendyS]

hi
null (-) they not empty values like what you have in column "AREA GENERA CONTACTO".

if you want to change that, you need to define which value you want to replace with null ( I guess you want to replace the null with space or 0)  and after that the color condition work as you define