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

    How to highlight an expression based on another column value?

      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.




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


      Please advise,