Set analyses ? - using OR

[ivan_will]

hello,

how can I convert this function - sum ( distinct IF (a='1' OR a='2 , (b) , 0)) into set analyses function ?

sum ( { $<a = {'1' ???????????? '2'}>} b)

[Anonymous]

this should do:

sum( $ {< a = {'1','2'} >} b)

Anita

[ivan_will]

😞 no, it doesn't work !

[Miguel_Angel_Baeyens]

If that concerns to distinct, try

Sum({< a = {"1","2"} >} DISTINCT b)

[Miguel_Angel_Baeyens]

Even, when working with numeric values

Sum({< a = {1,2} >} DISTINCT b)

[ivan_will]

No , it does not work again ! I need - OR

This function Sum({< a = {1,2} >} b) = + between 1and 2 /////// , - means +

[Anonymous]

a = {1,2} means that a should be 1 or 2