Solved

Crystal Reports: Sum group totals in a formula style

Posted on 2012-03-21
3
749 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

752 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