3 Replies Latest reply: May 8, 2014 2:06 AM by Sergey Makushinsky RSS

    How to highlight an expression based on another column value?

    Saravanan Vijaya Sundaram

      Dear Experts,

      We have a scenario like, when we input item#, the bar chart output shows all those vendors supplying this item. But only one vendor can be active at a time. We would like to highlight active vendor in GREEN color and the others should be in 'WHITE' color.

      Active/Inactive vendor is controlled by a field 'ASL_COMMENTS'. Only for active suppliers this field will be NULL.

       

      We tried with below expression in the colors tab. But it's not working.

       

      if

       

      (isnull(ASL_COMMENTS), green(),white())

       

      Please advise,

      Thanks,

      Saravanan