3 Replies Latest reply: Nov 13, 2014 2:29 AM by Manish Kachhia RSS

    Hiding row if Condition

    Bashar Khalid

      Hi,

       

      I have the following image represented expression.

       

      if(Column(1)>Column(2),'red.png',if(Column(1)=Column(2),'green.png','yellow.png'))

       

      Basically, Column 1 and Column 2 contain numbers and I want to see if there is a difference between them by adding a colored smiley face on the right of each row. but now, I want to only reveal the rows where column 1 and column 2 are NOT equal to each other, meaning instead of showing the "green.png" I want to hide the whole row because I don't need to see it anymore.

       

      How do i do this?