Need Summation logic at set analysis

[agni_gold]

Hi Friends,

I have a situation  ,

Where i want to show only data for below condition

Negative MACO and Positive Vol , attaching my sample data also .

It is required to do this at frontend  level.

[MindaugasBacius]

Maybe this could help?

[vinieme12]

Try as below

sum({<Account = {'Maco'} , Value = {"<0"}>}Value)

sum({<Account = {'Vol'} , Value = {">0"}>}Value)

[agni_gold]

in a single condition , it is not possible ?

[agni_gold]

I need here , only to come one row for vol which is

A ------------   3

[vinieme12]

what exactly do you want to evaluate? please clarify

sum({<Account = {'Maco'} , Value = {"<0"}>}Value)

+

sum({<Account = {'Vol'} , Value = {">0"}>}Value)

[agni_gold]

I need here , only to come one row for vol which is

A ------------   3

which is satisfying below condition

Negative MACO and Positive Vol

[vinieme12]

SUM( if((Account = 'Maco' AND Value <0) OR (Account='Vol' and Value > 0 ),Value) )

or

sum({<Account = {'Maco'} , Value = {"<0"}>}Value)

+

sum({<Account = {'Vol'} , Value = {">0"}>}Value)

[agni_gold]

Not working

[vinieme12]

Works for me