Crystal Reports: Sum group totals in a formula style

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?
Maliki HassaniAsked:
Who is Participating?
 
mlmccCommented:
Try it this way


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

mlmcc
0
 
Maliki HassaniAuthor Commented:
Great..  I think this should work.  I will let you know.. Thanks
0
 
Maliki HassaniAuthor Commented:
Perfect!!  Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.