How can we set text color in pivot table when data is null?

[#1]

Hi all, I try to set text color.
I want the Node that starts with "TTL___" and "STTL" have blue color. And I set the text color with this code

if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL'),RGB(0,0,204),black())

It's work. But some data still not change the color. I'm not sure, its will concern with the value of another dimension that has value = 0.

So I try to use suppress nulls data. But some rows still have a problem, the text in Catalogue column is not change color. But in the same row, some data already change to blue color.

Now I try to change expression in text color to support my design.
I use this code:

if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL') ,RGB(0,0,204),
if((if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL'),RGB(0,0,204),black()=black()and if((Amt.=0),1,0)=1)) ,RGB(0,0,204),black()))

It's nearly the design what I want. The texts that start with 'TTL___' and 'STTL' changed to blue color. But the others texts that has null value change the color too.

Could someone help me or suggest any better way to handle these issues?

Regards

[#2]

If I understand correctly, you want to change color of data(amt=0) to blue also.

Please attached I applied the same expression for text amt and % you have for catalogue. May be you can refine your expression, not sure about that.

=
if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL') ,RGB(0,0,204),
if((if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL'),RGB(0,0,204),black()=black()and if((Amt.=0),1,0)=1)) ,RGB(0,0,204),
black()))

[#3]

Hi,Devang

Thank you for your respond. Actually I want to change text color of field that has word "TTL__" and "STTL". Now it's work but it's also change text color of field that has word "GL" and "CE" too.

How can I ignore FICO_NodeGroup that has word "GL" or "CE" ?

[#4]

Hi, Any one have work around on this ? Pls help me. Regards

[#5]

I still don't know how to fix this problem.