Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.