Hello,
i thought before that its only possible to change the color of the whole column of a value list dimension.
First I have a regular Value list dimension like this:
If(ValueList('Daily','Workforce','8888')='Daily', count..........., If(ValueList('Daily','Workforce','8888')='Workforce'.....count....and so on
In a straight table I don't want to change the value fields for 'Workforce' and '8888' but for 'Daily'
Adding to the regular dimension column, I can put in the field function for color in the straight table a similar value list function to adress only the dimension I want to change:
If(ValueList('Daily','Workforce','8888')='Daily' ,
rgb(192,0,0),0)
Now every value I get will be displayed in red. But I want to put another condition: Only when the value is bigger than zero. Zero values should stay white.
How to write the nested or addtional condition to make that?
Thanks in advance.