SET Analysis

[#1]

Hi,

cannot get the below to work. Both are showing the very same result. Any ideas?

Sum({$<Amount = {"<0"}>}{$<Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"}>}{$<Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Best regards,

Olle

[Anonymous]

Hi,

Please can you elaborate on your expected output.

[Anonymous]

Try:

Sum({$<Amount = {"<0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

[morganaaron]

Hi Olle,

You don't need to create a new set, just to continue modifying the same set.

Try:

Sum({$<Amount = {"<0"}, Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"}, Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

[#5]

I need to sum up all positive values, for all counterparts, except XXX, YYY and QQQ

Same goes for negative values

//O

[Anonymous · Accepted solution]

Try this and Update its working:

Sum({$<Amount = {"<0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)

Sum({$<Amount = {">0"},Counterpart -= {'XXXX', 'YYYYY', 'QQQQQ'}>}Amount)