2 Replies Latest reply: Sep 8, 2016 3:44 PM by Ugonna Okoli RSS

    conditional colors in a bar chart

    michele della mea

      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?