Solved

Crystal Reports: Sum group totals in a formula style

Posted on 2012-03-21
3
748 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 100

Accepted Solution

by:
mlmcc earned 500 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

Independent Software Vendors: 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

Suggested Solutions

Title # Comments Views Activity
SQL Recursion 6 33
Analyze Shared Variable? 7 28
SQL Query Syntax error after > 11 41
Changing the Schema for all Tables in a Tables - MS SQL Server 2008 R2. 3 30
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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