5 Replies Latest reply: Mar 14, 2016 9:59 AM by Sunny Talwar RSS

    Change bar chart colour based on a calculate field - syntax

      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