Incorrect SUM in aggregation

[former_member299995]

Hi experts,

I have a problem in a view of calculation, projection type, there is an aggregation node in modeling. The hana is suppressing duplicate values ​​in SUM (see attachment) .

How I do correctly sum of these values​? The blue marked values ​​are ignored and the red marked value ( result of the sum ) is incorrect, the correct value and 2420 .

Best regards.

[former_member299995 · Accepted solution]

Hi all! I´ve solved this problem.

The data input of this calculation view is another calculation view. In the origin calculation view the parameter was setted to 'ATTRIBUTE'. Just change to 'MEASURE' and HANA do not suppress duplicated values anymore.

Thanks all!

Regards