Filter Out data from Dataset

[Klachner]

I am trying to filter out data from my dataset. I want to filter out data that match two conditions in two columns in my workflow. Here is the formula I have written out but this is going to filter the data for this data and I want everything but this data

Contains([CountDistinct_receiving_entity], "1") and contains([Allocation Condition],"X"

[binuacs]

@Klachner can you try 

!Contains(toString([CountDistinct_receiving_entity]), "1") and !contains([Allocation Condition],"X")

[Klachner]

The error I get is "Parse Error at char (2): Formula tried to apply string operator to numeric value (contains)"

[binuacs · Accepted solution]

@Klachner updated the original post

!Contains(toString([CountDistinct_receiving_entity]), "1") and !contains([Allocation Condition],"X")

[Klachner]

Amazing! Thank you!

[Klachner]

Upon further review.. this formula is filtering out both CountDistinct_receiving_entity]),=1 AND Allocation Condition= X... I want it to have to meet both conditions to be filtered out. So if CountDistinct_receiving_entity =1 and Allocation Condition is Y i want that data to stay in the dataset