3 Replies Latest reply on May 28, 2012 5:03 PM by ahcho

    Filter Values

    ahcho

      Title

      Filter Values

      Post

      Hello!

      Trying to figure out a filter values list. Say I have a Column within a Table that has the following data:

      [1,1,2,2,1]

      I want to write an IF statement that tells me if there is a 2 in that column.

      The expression FilterValues(List(Table::Column); "2") will give the result [2,2]. What is the next function that I need to add that just tells me there is the occurance of a value "2" in the list?

      Aaron