Total of amounts on a Group Footer row?

Chris Z

Is there a way in Crystal Reports to take the Sum fields in a Group Footer and total them to get one amount for each unique group footer?


For example, if I have 5 gift officers, and each have 3 totals (one for Annual, one for Restricted, and one for Capital), can I get the sum of all 3 totals on the same line in a field to the right?

  Annual Restr Capital TOTAL 1000 0 5000 6000 0 5000 2500 7500 0 0 500 500 5000 5000 0 10000 0 50000 0 50000 6000 60000 8000 74000

GO1

GO2

GO3

GO4

GO5

TOTAL

The closest I've been able to get is for the GO1 Total to repeat with the same amount on every row, which isn't correct.


Just a note that I'm not using a cross-tab on this.  I tried working with that, but couldn't figure that out.


Thank you.

James Andrews

Are there gifts that don't fall into those three categories?  If not, then you could just insert another summary of the gift amount in that group footer.


If so, you could write a formula that says basically, if the gift is annual, restricted or capital then return the gift amount, else 0, and sum on that.


Alternately you could do a running total based on a formula that chooses the gifts you want and resets on the group you want.

 

Steven Cianciarulo

James's second option is my preferred method of dealing with this. It may not be the most elegant solution but here's what I do:

• Formula 1, group the gifts
  • One formula to categorize the way I want, e.g. If [Campaign] = "Tribute" then "Unrestricted"  and so on for each group
• Formula 2, return the the gift amounts for a specific category, one formula for each category
  • If [Formula 1] = "Unrestricted" then [Gift Amount]
• Formula 3, sum, once for each category
  • Sum[Formula 2]

My syntax might be off, but I think you get the idea!