Solved

Crystal Reports: Sum group totals in a formula style

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

746 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now