Topic: Total doubling Posted: 22 Aug 2012 at 6:21am
Hello, I am trying to get a total at a certain level in my report, and for some reason it keeps doubling my total. What would cause this to happen? Help! it's driving me insane!!! I keep looking at it and trying different things, but to no avail. Any help out there would be greatly appreciated. Thanks!
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 22 Aug 2012 at 8:56am
likely you have ajoin in your report that is causing you to get twice teh rows you expect.
Suppressing rows do not exlcude them from calcualtions. You have to manually exclude the duplications by using Running Totals or Variable Formula calculations.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
I keep looking at it and trying different things, but to no avail. Any help out there would be greatly appreciated. Thanks!
IP Logged
