Background Color on Dimension "Bug" ?

[#1]

I am trying to highlight the color of a dimension depending on a Flag value, but found that if the value of the first column is null, it failed to work. Want to know whether anyone encountered this problem. Is this a bug, design flag or I am using the method wrongly.

Eg:

Table fields: Date, Flag, Product, Value

Date Dimension-> Background Color = If (Flag=1,RED())

When I added a Total and show it at the first column, the logic works but without Total it does not work, or it will also show if the first value contains value.

Any advise will be appreciated. Am using QV Client Ver 9.00.7320.7 SR2.

[#2]

Hi,

You can solve it.

Press right button in the pivot table, in the tab "Presentation", uncheck "suppress zero values" and it's works well.

Sorry I dont speak english very well.

[stevedark]

Hi,

I can confirm that 'suppress zero values' works - thanks for the tip.

Regards,
Steve

[#4]

Hi all,

now I found the same problem as limch and I try to do following your suggestion. But It's not work. Despite I uncheck "suppress zero values" ,some filed that has null value still not change the color.

This is my code :

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

Could someone tell me how can I solve this problem?

Regards.