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

[saimahasan]

Thanks for your suggestion but it didnt work. It gives the same output as i am getting now. I want to show the color somehow against the values where total is blank. Actually i am using "Suppress values when null" checkbox because of which the total becomes null and therefore that value is losing its color. If i uncheck the option "Suppress values when null" then i am getting blue color all over.

[jonathandienst]

I suspect that the 0 values are neither 0 nor null, they are missing values. In this case, the expression is not evaluated at all.

Missing values are caused by incomplete associations. For examples sales in the sales table for a division that is not present in the divisions table. The division name will be missing as the association is incomplete.

[c_gilbert]

Have you tried right clicking on the column, then choosing 'Custom Format Cell' and changing the Text Color to blue?

If this is not available when you right click, go to Document Properties and change the Styling Mode to Advanced.

[saimahasan]

Yes Gilbert,

I have even tried this option but its not working for those items where Total value is 0. And wherever its decimal value be it 0.something, its working.

Problem is only with 0 values.

Please suggest

[saimahasan]

Hi John,

These values a re not missing values. These values a re summation and hence they are either 0 or some number. But since i have suppressed 0 values, the integer number 0 disappears resulting in black text color and the decimal number stays leaving the  text color as blue.

[c_gilbert]

Could you post a sample qvw?

[saimahasan]

Sorry i cannot post sample data. since the data is confidential

[jonathandienst]

If they are not missing values, but nulls, then this should work:

if(Len(Column(1) = 0 Or dimensionality()>=0,Blue())

[saimahasan]

Hi

They are actually 0 values. But since i have suppressed zero values, they are showing it as blank and hence the color deosnt applies.

[jonathandienst]

That's not how suppressing zeroes works. The suppress zeroes option removes the entire line if ALL the expressions evaluate to null or zero. Suppressing zeroes does not change zero to blank.

The problem lines are not being suppressed, so there are non-zero/null values elsewhere in these rows and the suppress will have no effect.