Trying to figure out a filter values list. Say I have a Column within a Table that has the following data:
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?