Multiple conditions in a field using IF clause

[#1]

Hi

I have to check the following condition in my requirement

=Count( Distinct if( StageID =7 or StageID=8 or StageID=9 ,UserID))

Is there any way to handle the above condition like we do in sql : StageID in (7,8,9) in my IF condition.

[MayilVahanan · Accepted solution]

Hi

Try like this

= Count({<StageID = {7,8,9}>} Distinct UserID)

or

=Count( Distinct if( match(StageID,7,8,9) ,UserID))

[tresesco]

Try match() function. In general multiple ORs should be better handled by match().

[CELAMBARASAN]

For this type of requirement you have to go with set analysis.

Count( {<StageID ={7,8 ,9}>} Distinct UserID)

Hope it helps

Celambarasan

[#5]

I want to use it in an expression is that possible?

[#6]

I have other conditions to check too.Without using set analysis is there any other option??