Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
segerchr
Contributor III
Contributor III

Set Analysis not equal

Hey,

the option -= does not work in my example. Can anyone help me ?

count({1<Art={'Training'},Urlaub-={'x'}>}SpielerID)/count(Total Distinct SpielerID)

The code for = does work.

count({1<Art={'Training'},Urlaub={'x'}>}SpielerID)/count(Total Distinct SpielerID).

BR. CS

11 Replies
swuehl
MVP
MVP

Well, it depends if you want to use OR or AND logic to combine your conditions:

=count({1<Art={'Training'},KEY =e({<Urlaub={'x'}>+<verletzt = {'x'}>+<krank = {'x'}>}) >} DISTINCT SpielerID)

=count({1<Art={'Training'},KEY =e({<Urlaub={'x'}, verletzt = {'x'}, krank = {'x'}>}) >} DISTINCT SpielerID)

segerchr
Contributor III
Contributor III
Author

Thanks so much. It works fine