Sum with duplicate data

[zhaohaifeng]

Hi All,

For some case :

Sum({<A={CHC}>} VALUE ) + Sum({<A={GEM}>} VALUE )  are not matched with Sum({<A={CHC,GEM}>} VALUE )  as the duplicate data, my question was that if we want to calculate all the value not carethe duplicate like Sum({<A={CHC}>} VALUE ) + Sum({<A={GEM}>} VALUE ) , how can we edit the expression dont used this way one + one. Thanks for your time!

Best Regards,

Haifeng

[bramkn]

maybe Sum({<A={CHC}>+<A={GEM}>} VALUE )

[zhaohaifeng]

Hi,

If we need to calculate all the items, in this way we need to write many set analysis, A=CHC + A=GEM+A=AAA+ and so on, so do you know any other ways ? Thanks.

Best Regards,

Haifeng

[sunny_talwar]

AFAIK Sum({<A={CHC}>} VALUE ) + Sum({<A={GEM}>} VALUE) will always equal Sum({<A={CHC,GEM}>} VALUE)... can you share a scenario where they are not?

[zhaohaifeng]

Thanks .

See attached file, the sum value we want to show 700, not 600. Can you share some ideas? Thanks.

Best Regards,

Haifeng

[sunny_talwar · Accepted solution]

You can try this as your expression

Sum(Aggr(Sum(value), AA, org))