Outer Join in set analysis

[danimelo1]

Hello all,

How Can I count the number of persons given the following in set analysis?

I was trying this, but it didn't give the results that I need

count( {<Placement-={''}>+<Successor-={''}> }distinct [Person ID])

[jonathandienst · Accepted solution]

Use the '/' XOR set operator (either A or B, but not both)

Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])

[jonathandienst]

Or better,(unless you are explicitly filtering for blanks strings):

Count({<Placement = P(Placement)>/<Successor = P(Successor)>} Distinct [Person ID])

[Anil_Babu_Samineni]

Seems okay to me, What is the wrong and what are you trying here?

count( {<Placement-={'*'}-{''}>+<Successor-={'*'}-{''}>} distinct [Person ID])

OR

count( {<Placement-={"=Null()"}>/<Successor-={"=Null()"}>} distinct [Person ID])

[danimelo1]

This one worked to me!

Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])