Set Analysis And + Or

[ilanbaruch]

hi all

in my model I have an expression based set Analysis 'OR' :

Count({$<Flag_1={'1'}>+<Flag_2={'1'}> } distinct client_id)

I want to add another flag to the expression 'AND'  Flag_3 

any ideas ?

advanced thanks

[edwin]

if you add Flag_3 inside each of the modifiers that will be equivalent to an AND:
<Flag_1={'1'},Flag_3={'1'}>

[MayilVahanan · Accepted solution]

Hi @ilanbaruch 

Try like below

Count({$<Flag_1={'1'},Flag_3 ={1}>+<Flag_2={'1'},Flag_3 ={1}> } distinct client_id)