none
Crystal Reports - Percent of total on each group RRS feed

  • Pergunta

  • 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

    sábado, 1 de junho de 2013 14:30