change the text color in dimension

[settu_periasamy]

Hi Guys,

I have to change the text color  in  the dimension value. like the below screen shot.

I need to change the text color (Only Not Assigned) should be red. First two columns are in dimension, third one is expression.

Thanks in Advance.

regards,

sethu

[SunilChauhan]

expand + sign before dimension

select test color and type there you color code

for Ex RGb(180,180,180) for gray

hope this helps

[Anonymous]

Go to Dimensions->Click the + Symbol->Text Color->Edit->If(Field='Not Assigned',Red())

[settu_periasamy]

Thank you. But, if  i mentioned the Null Symbol and Missing Symbol as Not Assigned in the presentation tab, i'm not able to change the color in the table. see the below screen shot.

can you help on this?

[SunilChauhan]

in  text color of dimension

you can write like below

if(fieldname='Not Assigned' , Red(),Green())

take your fieldname in place of fieldname
and write in both fields

hope this helps

[Anonymous · Accepted solution]

Try this in

If(Isnull(Fieldname),Red())

[settu_periasamy]

Thank you. This works.

[datanibbler]

Hi,

I have not really tried this out before - but I would guess you are right, Jebamalai. That 'Not assigned' is seemingly only a text which sethu has entered in the dialog (to be displayed), it is not the value that is actually in the field?

<=> You would probably have to make the colour dependent on the actual value, not the value that is to be displayed - alternatively you could assign this on scripting level.

Best regards,

DataNibbler

[anbu1984]

If(Field Is Null Or Field='Not Assigned',Red())