Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Unable to Sum on Group Name Fields. Please help. Post Reply Post New Topic
Author Message
dawnh44
Groupie
Groupie


Joined: 25 Sep 2011
Online Status: Offline
Posts: 79
Quote dawnh44 Replybullet Topic: Unable to Sum on Group Name Fields. Please help.
    Posted: 18 Oct 2011 at 6:49am
Please see question at the bottom:
 
 
Queue
Date Call Count Avg. Wait Time Abnd Abnd %
English Language Line 10/17/2011 309 0:0:39 11 3.6%
Spanish Language Line 10/17/2011 81 0:0:50 5 6.2%
Totals 387 0:0:41 16 4.1%
 
Hello,
 
As you can see, the Call Count is not summarizing correctly.  The two fields are are Group Name fields that are summarized based on Sequence Number and "Calculate this summary" by using Distinct Count.  I thought I could just put a Summary fied under the 2 counts to get the sum, but I was incorrect.  Does anyone know how I can get this to sum the numbers correctly?
 
Thank you in advance.
 
 
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 18 Oct 2011 at 6:57am
if the summing is conditional. a running total or shared variables needs to be done.
 
HTH
IP IP Logged
dawnh44
Groupie
Groupie


Joined: 25 Sep 2011
Online Status: Offline
Posts: 79
Quote dawnh44 Replybullet Posted: 21 Oct 2011 at 12:46pm
Hello Lockwelle,
 
First, I want to apologize for not getting back to you.  It's been a crazy week at work.  One of those....if it could go wrong, it did.
 
Finally, I want to thank you.  You were right.  A variable had to be created. 
 
Thank you for your help.
 
 
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.033 seconds.