Filter Out

Klachner

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

This formula is filtering out when CountDistinct_receiving_entity]),=1 AND when the Allocation Condition= X

I want it to have to meet both conditions to be filtered out.

Examples of data I want to stay in the dataset.

[CountDistinct_receiving_entity] = 1 and [Allocation Condition] = Y

[CountDistinct_receiving_entity] = 2 and [Allocation Condition] = X

[CountDistinct_receiving_entity] = 2 and [Allocation Condition] = Y

Datasets

Input

Output

Custom Tools

Connectors

Database Connection

Accepted answers

cjaneczko

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

All comments

alexnajm

I would do just that then - make your condition [CountDistinct_receiving_entity]=1 and contains([Allocation Condition],"Y")

Klachner

But i have multiple options for Count_Distinct_receiving_entity not just 1.

alexnajm

Ok then can you update this statement from above to be what you need?

"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"

Klachner

I think that accurately describes that I want it to have to meet both criteria in order to be filtered out. If only one of the conditions is met, I want it to stay in the dataset. I tried to update the original post with examples. Let me know if that helps

cjaneczko

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

alexnajm

It does help, but I also think my original answer still fits then: [CountDistinct_receiving_entity]=1 and contains([Allocation Condition],"X")

You would just keep the F anchor instead of the T anchor!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703