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

OR & AND with a SET ANALYSIS

Hello guys, 

 

Need some help again about set analysis expression 

Cause I don't want to use if everywhere I need to manage with the set analysis expression 

This is my table  : 

chapil_1-1636735780626.png

 

 

So I want to select : 

Immo name = 1  and  asset_number_null =1 or (asset_number_null=0 and <500 =1)

I don't have the solution to do the "or" 

the correct answer here will be : all expect the last one

 

I'm asking cause I m not sure this is working as well : 

Count({$ < [Immo name]= {1}, [Asset number null] = {1}, [<500]= {1}>} ID)

Thanks in advance for your help 

 

NB: All my mesure are calculated

 

Labels (4)
1 Reply
Digvijay_Singh

Something like this may be, didn't test though - 

Count({$ < [Immo name]= {1}, [Asset number null] = {1}> +
<[<500]= {1},[Asset number null] = {0}>}
ID)