3 Replies Latest reply on Mar 30, 2016 8:09 AM by Jyothirmayee Akula

    Condition color format

    John Smith

      Hello Guys,

       

      I have an issue with color coding in the report.

      Even after applying formula color coding is not effected under measure E.

      E -suppose to be Blue not 'RED'

       

      Screen shot difference.

      Condition calculated:

      IF [ESTIMATE]<[Target] THEN 'RED' ELSEIF [ESTIMATE]>[Target]

      THEN 'yelloW'

      ELSE 'GREEN' END

       

      REPORT1.png

       

       

       

       

       

       

      Kindly suggest me best possible solution to come out of this issue.

       

      Thanks

      John