topic Re: Color formula in App Development

Color formula

tim_m — Fri, 20 Apr 2018 04:48:56 GMT

Hi Folks,

my color Expression if(SUM({<[Account]={'Product B'}>}VALUE)<0, red(),black())

Please can you help me, why the following negative values are black colored, although my Expression is defined in red?

And how it is possible to color the line in a different color? This is my Plan-Line. This color alters if I use the expression above. It is possible?

Thank you!

sunny_talwar — Fri, 20 Apr 2018 11:31:07 GMT

What is the expression that you use for your chart? Do you have other set analysis that ignore some other selections when plotting the chart?

Anonymous — Fri, 20 Apr 2018 11:36:10 GMT

You have another set that force the black color, it may be in the chart parameter.

Try to put only that expression in a new table.

tim_m — Fri, 20 Apr 2018 13:25:15 GMT

No I have no further Filters or other selections.

tim_m — Fri, 20 Apr 2018 13:25:58 GMT

Please can you explain where I find this setting? In Colors I can set the black color but I want to set the line in red

sunny_talwar — Fri, 20 Apr 2018 13:27:10 GMT

What is your chart expression?

tim_m — Fri, 20 Apr 2018 13:31:42 GMT

Target Expression

SUM({<[Account]={'Produkt B'},SALES={'targeted amount'}>}Value)

Actual Expression

SUM({<[Account]={'Produkt B'},SALES={'actual amount'}>}Value)

Are my both Expressions.

sunny_talwar — Fri, 20 Apr 2018 13:33:33 GMT

Which one is represented for the bar? actual? May be try this

if(SUM({<[Account]={'Product B'},SALES={'actual amount'}>}VALUE)<0, red(),black())

Anonymous — Fri, 20 Apr 2018 13:38:32 GMT

where you did put your color expression. have you another color expressions?

tim_m — Fri, 20 Apr 2018 13:42:00 GMT

in multi color I have no black possible