Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
this should do:
sum( $ {< a = {'1','2'} >} b)
Anita
😞 no, it doesn't work !
If that concerns to distinct, try
Sum({< a = {"1","2"} >} DISTINCT b)
Even, when working with numeric values
Sum({< a = {1,2} >} DISTINCT b)
No , it does not work again ! I need - OR
This function Sum({< a = {1,2} >} b) = + between 1and 2 /////// , - means +
a = {1,2} means that a should be 1 or 2