Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Double Counting a Value Post Reply Post New Topic
Author Message
thesmug1
Newbie
Newbie
Avatar

Joined: 12 Jun 2009
Online Status: Offline
Posts: 13
Quote thesmug1 Replybullet 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.

-MG
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Feb 2011 at 10:24am
use a running total to only add the value on change of a field that makes sense for this concept like accessorial
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.