Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
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
Something like this may be, didn't test though -
Count({$ < [Immo name]= {1}, [Asset number null] = {1}> +
<[<500]= {1},[Asset number null] = {0}>}
ID)