or in set analysis

[ioannagr]

Hello.

I have formed this expression 

Count( {<[reason is]={'this'}>+<[reason is]={'that'}>} distinct [row id])/ count([reason is])

and I get 0, while Count( {<[reason is]={'this'}>} distinct [row id])  alone is approx. 2000 

and so is Count( {<[reason is]={'that'}>} distinct [row id])    .

What could possibly be wrong?

[agigliotti]

your expression looks good.

what you get  for  the expression =count([reason is]) ?

[ioannagr]

43,7K 🤔

[tresesco · Accepted solution]

If you put values for a field separated by comma, they are OR by default in set analysis. Therefore, you could simply try like:

Count( {<[reason is]={'this', 'that'}>} distinct [row id])/ count([reason is])

[mfarsln]

Hi,

Try this;

Count( {<[reason is]={"this","that"}>} distinct [row id])/ count([reason is])

[ioannagr]

Thanks guys!

What would it be if I wanted the "and" clause?

PS: It's strange how  in one app for "or" the plus sign works (i've done this before) and for this one it doesn't. Why is that?

[agigliotti]

for AND clause:

Count( {<[reason is]={'this'}> * <[reason is]={'that'}>} distinct [row id])/ count([reason is])

[mfarsln]

Hi,

For the 'and' clause;

Count( {<[reason is]={'this'},[another_field]={'something'}>} distinct [row id])/ count([reason is])

or

Count( {<[reason is]={'this'}>*<[another_field]={'something'}>} distinct [row id])/ count([reason is])

[ioannagr]

Thanks a bunch 🙂