How Can I Change the Color?

[pnn44794]

Hello:

I have thermometer chart using the following expression and I would like to make the "Finance*", Implementation, Confidence = {High} segment to be a light green and the third Sum to be Yellow.  Is there a way to do that?

As always, thanks in advance for any and all help.

[pnn44794]

The expression gives me the amount that has been booked (first Sum – dark green), the amount that looks like it will get booked (second Sum – light green) and then everything else that is outstanding that may or may not get booked (third Sum - yellow). Make sense? The expression does what it’s supposed to do, except how I do change the thermometer colors to coincide with each Sum (3 sums / colors)?

[pnn44794]

Anil, I’m going offline. If or should you respond, I promise I will get back to you tomorrow. Again, I appreciate your assistance.

[Anil_Babu_Samineni]

Looks sense? May be share sample to investigate. Tomorrow also fine

[pnn44794]

Hello Anil:

My apologies for the delay (fighting a bad cold and feeling like crap, anyway.......).

[Anil_Babu_Samineni]

Can you try this?

ColorMix2 (if(rangemin('$218.1',rangemax(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000)  +

Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000  +

Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'),'$180.6'))<'$195.2',

-Sqrt(-(rangemin('$218.1',rangemax(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000)  +

Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000  +

Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'),'$180.6'))-'$195.2')/('$195.2'-'$180.6')),

Sqrt((rangemin('$218.1',rangemax(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000)  +

Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000  +

Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'),'$180.6'))-'$195.2')/('$218.1'-'$195.2'))),

ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0), ARGB(255, 255, 255, 0))

[pnn44794]

Hello Anil:

I tried the above expression.

[pnn44794]

Ok.

[Anil_Babu_Samineni]

Checking ...!

[Anil_Babu_Samineni]

I didn't get thru Work. I will wish to learn from cleveranjos‌

[pnn44794]

Hello Anil:

I'm not sure I understand your reply.  My apologies.