Joined: 12 Jun 2009
Online Status: Offline
Posts: 13
Topic: Double Counting a Value Posted: 08 Feb 2011 at 10:07am
Hello,
My report's double counting a value, and I need help correcting it. The idea behind the report was to itemize accessorial charges on our freight bills. Most of the bills only have one charge, but every once in awhile some have two. The important columns in my report are Charges, Accessorial Charges, and Total Charges. For the bills that only have one Accessorial, the report works great. However, when the bills have multiple Accessorials, the summary adds the Charge for each individual Accessorial. So if there were two Accessorials, it would add the Charge two times. I was wondering if anyone knew how to remedy this. Any help would be greatly appreciated.
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