Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this:
If(Sum(cost)/Sum(ricavo) < 0.70, Green(), If(Sum(cost)/Sum(ricavo) < 0.75, Yellow(), Red()))
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())))