Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Crystal Reports: Sum group totals in a formula style

Posted on 2012-03-21
3
Medium Priority
?
756 Views
Last Modified: 2012-03-22
Hi Experts,

This is driving me crazy..
I have a report that I am trying to use this type of formula.  impact score / group (total impact score).

What this means is that I am trying to show  for each record (row), divide the impact score into the total impact score of the the group.  Key word is the group.  If I create a formula like Sum({Impact_score})  it gives me the total for the report not the group.

Any ideas?
0
Comment
Question by:Maliki Hassani
  • 2
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 37749578
Try it this way


{ImpactField} / Sum({Impact_score},{GroupField})

mlmcc
0
 

Author Comment

by:Maliki Hassani
ID: 37749902
Great..  I think this should work.  I will let you know.. Thanks
0
 

Author Closing Comment

by:Maliki Hassani
ID: 37753370
Perfect!!  Thank you
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Loops Section Overview
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question