Set analysys - "Not in"

[#1]

Hello,

I´ve a table with customers and situation code (300 or 302). Some customers can have both situation code and others can have just one of them.

What are the expression that let me know which customers does have just one situation code? (300 or 302).

Thank you

[#2]

I need to know which customers have situation code=300 AND don´t have situation code=302

[Anonymous · Accepted solution]

Hi try this

sum({$<customer = p({$<code={'300'}>}

customer) - p({$<code={'302'}>}

customer)>} Sales)

[#4]

Hello Alfasierra,

This code above is working fine! Thank you.

Now... which is the expression to show me customers that have BOTH codes (300 and 302)?

Thank you

[alexpanjhc]

try

sum({$<customer = p({$<code={'300'}>}

customer)* p({$<code={'302'}>}

customer)>} Sales)