4 Replies Latest reply: Sep 11, 2014 11:34 AM by James Summerson

Dynamic opacity in ARGB() for table background color.

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

• Re: Dynamic opacity in ARGB() for table background color.

Hi Dave,

have You tried to use Wizard of ColorMix1 or ColorMix2 ?

Regards,

Antonio

• Re: Dynamic opacity in ARGB() for table background color.

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

• Re: Dynamic opacity in ARGB() for table background color.

In background color -> File -> Wizard.

• Re: Dynamic opacity in ARGB() for table background color.

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))