https://community.qlik.com/t5/App-Development/Aggregate-Sum-function-does-not-match/m-p/1891625#M73476 <P>Ok, so I've encountered a problem I can't seem to figure out the reason as to why it is happening.&nbsp; My summation in the pivot table does not equal the total of the availible data points. Sum([Belopp Brutto]) should aggragete over all facilities&nbsp;9260311015, but it gets a higher value. It is accurate for several other facilities, but not some have shouldn't so I guess my question is what am I missing?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ericus_0-1644510449684.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72054iD8AA1AD09F77D1A7/image-size/medium?v=v2&amp;px=400" role="button" title="Ericus_0-1644510449684.png" alt="Ericus_0-1644510449684.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ericus_1-1644510488261.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72055i76C2ED6AE6CA2D90/image-size/medium?v=v2&amp;px=400" role="button" title="Ericus_1-1644510488261.png" alt="Ericus_1-1644510488261.png" /></span></P> <P>&nbsp;</P> Thu, 10 Feb 2022 16:33:42 GMT Ericus 2022-02-10T16:33:42Z https://community.qlik.com/t5/App-Development/Aggregate-Sum-function-does-not-match/m-p/1891625#M73476 <P>Ok, so I've encountered a problem I can't seem to figure out the reason as to why it is happening.&nbsp; My summation in the pivot table does not equal the total of the availible data points. Sum([Belopp Brutto]) should aggragete over all facilities&nbsp;9260311015, but it gets a higher value. It is accurate for several other facilities, but not some have shouldn't so I guess my question is what am I missing?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ericus_0-1644510449684.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72054iD8AA1AD09F77D1A7/image-size/medium?v=v2&amp;px=400" role="button" title="Ericus_0-1644510449684.png" alt="Ericus_0-1644510449684.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ericus_1-1644510488261.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72055i76C2ED6AE6CA2D90/image-size/medium?v=v2&amp;px=400" role="button" title="Ericus_1-1644510488261.png" alt="Ericus_1-1644510488261.png" /></span></P> <P>&nbsp;</P> Thu, 10 Feb 2022 16:33:42 GMT https://community.qlik.com/t5/App-Development/Aggregate-Sum-function-does-not-match/m-p/1891625#M73476 Ericus 2022-02-10T16:33:42Z https://community.qlik.com/t5/App-Development/Aggregate-Sum-function-does-not-match/m-p/1891799#M73487 <P>Something tells me you have a couple of duplicated records. Create a table with Dim: Anlaggning and measure: Count(Anlaggning).&nbsp; Select that same value from your screenshot and I bet you'll get a count &gt; 3.&nbsp; I hope this helps</P> Fri, 11 Feb 2022 05:31:08 GMT https://community.qlik.com/t5/App-Development/Aggregate-Sum-function-does-not-match/m-p/1891799#M73487 albertovarela 2022-02-11T05:31:08Z