This content has been marked as final.
Show 4 replies

Re: Sum of values that follow some rules
Caio Lobato Jul 18, 2017 1:23 PM (in response to Caio Lobato)Sum({<Col2 = P({$<Col1={'x'}>}Col2) * P({$<Col1={'y'}>}Col2), Col4={0}>}Col3)
Even that this formula gives me the expected value, I was wondering if is really correct.
I am new using indirect set analysis and not sure if this case is ok to use that.
If someone has another alternative or some adjustment to the formula that I used, will be very welcome. 
Re: Sum of values that follow some rules
Sunny Talwar Jul 18, 2017 1:46 PM (in response to Caio Lobato)May be this
Sum({<Product = {"=Count(DISTINCT {<Col1 = {'x', 'y'}>} Col1) = 2"}, Col4 = {'#'}>}Col3)

Re: Sum of values that follow some rules
Sunny Talwar Jul 18, 2017 1:48 PM (in response to Sunny Talwar )
268079.qvw 149.2 K



Re: Sum of values that follow some rules
Michael Solomovich Jul 18, 2017 1:58 PM (in response to Caio Lobato)This works for me:
sum(if(aggr(nodistinct concat(Col1),Product)='xy' and Col4='#', Col3))