This content has been marked as final. Show 5 replies
Please can you assist. I have 2 dementions "Target Consumption" and "Actual Consumption". I would like my "Actual Consumption" to be a dynamic colour - to show up green on a bar chart if it's value is less than the "Target Consumption" and red if it's greater than the "Target Consumption"
I have tried to go to the charts, properties, colours and with the following expression
if([Fuel Consumption Standard]>[Fuel Consumption (Actual L/100km)],lightgreen(),lightred()
It's not working. Please help