Colors to Null symbol '-'

[Sra1bandi]

Hi Team,

In normal Table Need to fill colors in the  cell '-',.

i am using expression :-  If(not IsNull([Your Field]), [Your Field], ' ') 

with above function i am getting colors in empty cell but i am not getting color with the symbol in the cell '-'

How to fill  colors for the values '-' in the table?

Regards,

Sra1.

[ckarras22]

If the NULLs come from the load script, then you can use the NullAsValue and NullValue like below  

NullAsValue Phone;
Set NullValue = '-';

LOAD
    CustomerID,
    Name_CStmr,
    Phone
FROM [lib://ssdd/Customer - nulls.xlsx]
(ooxml, embedded labels, table is Customer);

then you can use it as usual in the table 

If the NULLs are generated on the fly, the "Background color expression" has no effect. The check happens before the NULL generation

[Sra1bandi]

Hi Ckarras,

Thanks for your reply.

I am used that also still it's not getting.