This content has been marked as final. Show 2 replies
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?