Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Use the '/' XOR set operator (either A or B, but not both)
Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])
Use the '/' XOR set operator (either A or B, but not both)
Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])
Or better,(unless you are explicitly filtering for blanks strings):
Count({<Placement = P(Placement)>/<Successor = P(Successor)>} Distinct [Person ID])
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])
This one worked to me!
Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])