Crystal Reports - Percent of total on each group

Question

Hi there,

I have a report:

QuestionGroup

  Question

     Answer 1 (10) ->nr of persons who answered "Answer 1"

     Answer 2 (3)

     Answer 3 (7)

     Answer 4 (0)

  Total: 20

• There are 3 groups: QuestionGroup->Question->Answer
• Total is a running total field (count), which resets every question (lets call it totalAnswersPerQuestion)
• Nr of persons who answered a specific question is a running total field (count), which resets every answer

My goal is to show percentage of people who answered specific questions (instead of having Answer 1 (10), heaving Answer 1 (50%)).

It would be good to have a formula field like "nrPeoplePerAnswer/totalAnswersPerQuestion*100". However, totalAnswersPerQuestion is calculated progressively, which means that when calculating nrPeoplePerAnswer at Answer 1, totalAnswersPerQuestion is 10 at the moment, which means the result is 100% (10/10*100).

Is there any way to do this?

Thanks in advance.

MP