Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
I added in expression that wherever the summation is 0 it should take it as null and then i supressed null values.
It worked. Now i am getting all Blue colours.
Thanks all for your help and replies.
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
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
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
I have used the following condition:
if(dimensionality()>0,Blue())
Hi Saima
Try This
if(dimensionality()>=0 and dimenstionality()<=0,Blue())
Regards
Hemanth
It removed all Blue color from that dimension.
try this
if(dimensionality()>=0,Blue())
if possible can u share the screen shot too
Regards
Hemanth
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.
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