topic Re: Sum aggregation did not match in App Development

Sum aggregation did not match

ecabanas — Tue, 26 Feb 2019 12:26:17 GMT

Hi,

I did a pivot table with several dimensions and trying to check the values I saw that the grand total did not match if you sum manually (see the screenshot attached)

Did anybody how to fix this calculation?

Thanks

See the aggregation screenshot

Re: Sum aggregation did not match

sunny_talwar — Tue, 26 Feb 2019 13:19:38 GMT

What expression are you using?

Re: Sum aggregation did not match

ecabanas — Tue, 26 Feb 2019 14:17:42 GMT

this is the expression

Sum({<[SalesId]={"PV0***"}>} Import_Brut)

thank's

Re: Sum aggregation did not match

sunny_talwar — Tue, 26 Feb 2019 19:44:01 GMT

This is strange, the sum should have been correct.. are you sure you are not rounding the numbers before exporting it to Excel?

Re: Sum aggregation did not match

ecabanas — Wed, 27 Feb 2019 10:23:25 GMT

no, no the exportation is correct, there are 4 dimensions and one measure

The measure is really simple

Sum({<[SalesId]={"PV0***"}>} Import_Brut)

thank's for your help

Re: Sum aggregation did not match

sunny_talwar — Wed, 27 Feb 2019 12:08:54 GMT

I see the issue, but I am not entirely sure what might be going on. May be someone else is able to help here