0 Replies Latest reply: Nov 30, 2015 8:16 AM by Claus Reinhard RSS

    Color Bar Chart by calculated dimension

    Claus Reinhard

      Hi everyone,

       

      I have a little coloring problem within one of my bar charts.

      Capture.PNG

      My Dimension definition looks like:

      =If(DATEDIFFERENCE >=20,dual('20 or more',20),If(DATEDIFFERENCE < -5,dual('-6 or less',-6),dual(DATEDIFFERENCE,DATEDIFFERENCE)))
      

       

      And my backgroundcolor definition on my expression states:

      If(DATEDIFFERENCE <= 0,Green(),Red())
      

       

      Unfortunatly "-6 or less" is colored red, although I want it to be colored green. Everything else works just fine. Has anyone an idea, how to accomplish this?

       

      Thanks in advance,

      Claus