Changing the text's font color

[saimahasan]

Hi All,

I have a dimension and i want the values of that dimension to be in blue. but wherever the total comes to 0 or null the text color doesnt change.

Please help

[its_anandrjs]

Share sample app with some data

or you can do click on the dimension >> and expand plus sign >> in Text Color write >> Blue()

Regards

Anand

[saimahasan]

I did it. Its already being set to Blue but still for some values wehere total comes to 0 i am not getting the font color as blue. I cannot share the application since its confidential data

[hemanthaanichet]

Hi Saima,

I think u given a condition for that blue color rite can u pls share that  condition with some changed names

Regards

Hemanth

[saimahasan]

I have used the following condition:

if(dimensionality()>0,Blue())

[hemanthaanichet]

Hi Saima

Try This

if(dimensionality()>=0 and dimenstionality()<=0,Blue())

Regards

Hemanth

[saimahasan]

It removed all Blue color from that dimension.

[hemanthaanichet]

try this

if(dimensionality()>=0,Blue())

if possible can u share the screen shot too

Regards

Hemanth

[saimahasan]

I have already shared the screenshot in my first thread. The problem is that wherever the Total is null or blank, only for those values in the dimension, the color doesnt appear as Blue. rest all the values for the same dimension appears blue.

[hemanthaanichet]

Hi Saima

product level is a dimension then follow these steps

may this u may know i think any how let give a try

right click-> properties-> dimension-> product level1

expand the + sign in that u vil find  background, textcolour, text format

click textcolor

functions

function category = color

function name = rgb(value1,value2,value3)

paste

apply ok

for reference have a look on the attachment

Regards

hemanth