Multiple Dimensions In Bar Chart, conditional coloring

[chrweber]

Hi,

I have a bar chart with two dimension,

the second dimension contains values e.g. 8 and 9.

I have a scenario where I have  one bar for each.

Now I wish to use the same color but different transparencies:

=Red($(=if([BogusAuxDim] = 8, 125, 255)))

But this does not evaluate, what am I missing?

Best Regards

[kfoudhaily]

i suggest:

=if([BogusAuxDim] = 8, rgb(255,0,0),rgb(255,100,100))

regards,

[jwjackso · Accepted solution]

=If([BogusAuxDim] = 8,Red(125),Red(255)

[chrweber]

Hi,

unfortunately this answer does not include transparency, which is what this question is about

[chrweber]

Interestingly, this works and it  allows the execution of my original intend:

=If([BogusAuxDim] = 8,White(125),White(255) bitand Red()

However I would still like an explanation why the other expression fails

[jonathandienst]

You almost had it, but you dont need a $ expansion:

=Red(if([BogusAuxDim] = 8, 125, 255))

[chrweber]

Well, that is just my problem.

I tried that, of course but then I get default colors.

The expression fails silently