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

    conditional colors in a bar chart

      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?