Dynamic opacity in ARGB() for table background color.

[#1]

Hello --

I'm attempting to change the background color of a table chart depending on how poor the dimension is performing.  I calculate the opacity of the ARGB() function by simply multiplying the percent change by 1000.  So if the dimension is performing 6% under from the year before the ARGB call would look like this: ARGB(60, 255, 0, 0).  I've played around with the function to make sure ridiculous numbers don't break it so ARGB(255, 255, 0, 0) works as well as ARGB(400000, 255, 0, 0).

Anyhow, it doesn't seem that putting the value in a field translates to a number ARGB() can use.  My function:  =If(change_percent <= 0, ARGB(opacity, 255, 0, 0)) that is behind the 'Background Color' doesn't work.  I've tried typecasting using Num() but that doesn't help.  Any suggestions?

Attached is an example.

Thanks,

Hudnutt

[antoniotiman]

Hi Dave,

have You tried to use Wizard of ColorMix1 or ColorMix2 ?

Regards,

Antonio

[#3]

I don't even know of such a thing.  I'll look into it.

[antoniotiman]

In background color -> File -> Wizard.

[ThornOfCrowns · Accepted solution]

You need to have a positive value in the A of ARGB, so muliply your opacity by -1:

=If(change_percent <= 0, ARGB(opacity*-1, 255, 0, 0))