topic Re: conditional colors in a bar chart in App Development

conditional colors in a bar chart

Thu, 08 Sep 2016 15:37:16 GMT

I would like to create a bar chart that shows the total revenues per city and the colour of every column depends on a division.

The formula is more or less the following:

IF(Sum(cost)/Sum(ricavo) >= 0.75, Red()),

IF(Sum(cost)/Sum(ricavo) < 0.75 and Sum(costo)/Sum(ricavo) >= 0.70, Yellow()),

IF(Sum(cost)/Sum(ri) < 0,70, Green())

As you can see there are three colors but obviously the expression doesn't work.

Can you help me?

sunny_talwar — Thu, 08 Sep 2016 19:29:45 GMT

Try this:

If(Sum(cost)/Sum(ricavo) < 0.70, Green(), If(Sum(cost)/Sum(ricavo) < 0.75, Yellow(), Red()))

Anonymous — Thu, 08 Sep 2016 19:44:45 GMT

if(Sum(cost)/Sum(ricavo) >=0.75, Red(),

if(Sum(cost)/Sum(ricavo) <0.75 and Sum(cost)/Sum(100) >=0.70, Yellow(),

if(Sum(cost)/Sum(ri) <0.70, Green())))