2 Replies Latest reply on Jun 18, 2018 12:08 PM by Jim Dehner

    Change color of bar depending if it exceeds target or not

    K Noo

      Hello. I am attaching a fiile here. What I am looking to do is is the bars (sales) meet or exceed the line (target sales), I want to have a green bar. If it fails to  meet the target, I want the bar to be red. I have been trying a few different things.

       

      I have the following calculated formula

       

      IF [Sales] >= [Sales target] THEN "Green"

      ELSEIF [Sales] < ([Sales target]) THEN "Red" END

       

      However, that did not work. If anyone can help please let me know.

       

      -Noo