Columns Not Adding Correctly

[mphekin12]

Hello,

I have a quick question that I'm hoping the community can help me with.  Attached is a screen shot of a table that I exported to Excel.  If you add the columns in the 'Current' column, the total at the bottom of that column is NOT correct.  I manually added the 'Should Be' column to show what the total should be.  Is there a reason this table is behaving like this?

Any information would be greatly appreciated!

[mphekin12]

Nicole,

Thanks so much for the offer, but it is a rather large .qvd and it has sensitive data in it.

[simondachstr]

Try using your aggr() function including NODISTINCT.

[mphekin12]

I wanted to thank you all for you help!  After a lot of QC it appears to be a data issue.