Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Summing Group Footer Values Post Reply Post New Topic
Author Message
bradlee27514
Newbie
Newbie


Joined: 24 Jun 2009
Location: United States
Online Status: Offline
Posts: 20
Quote bradlee27514 Replybullet Topic: Summing Group Footer Values
    Posted: 29 Jun 2009 at 11:05am
I am grouping by customer and then by invoice

GH1 Invoice | Amount
D         1 | $10
GF2     1 | $10
D         2 | $5
D         2 | $5
GF2      2 | $5
GF1   Total | $20

I want to sum the Amount in the GF2 field for the whole group.  However when I do I get $20, when I should get $15.  How can I make this sum work?

I tried creating a new formula to create data that would take into account repeat instances:
if
  {#count of items on invoice} > 1
then
  {@amount sum} / {#count of items on invoice}
else
  {@amount sum}
 
However when I tried to sum this field I got an error message that the field could not be summarized. 

I know there is a distinct count, but there is no distinct sum.  I want to sum the values for GF2 not for all of the detail rows. 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Jun 2009 at 1:45pm
Use a RT as a SUM but set the evaluate for section to once per group (group2) and reset at GROUP1 palced on GF1.

Edited by DBlank - 29 Jun 2009 at 1:46pm
IP IP Logged
bradlee27514
Newbie
Newbie


Joined: 24 Jun 2009
Location: United States
Online Status: Offline
Posts: 20
Quote bradlee27514 Replybullet Posted: 29 Jun 2009 at 1:54pm
Thank you so much!  
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.016 seconds.