Cross Tab try to calculate percent of "Yes" from my survey.

[ker0k3n0]

Hello,
I am trying to create a cross tab to show survey question as row, survey ID as column, and the display answer as the summary. I have a formula which assign 1 if the answer is "Yes", and 0 if the answer is "No".

CountofYes formula:
if ({ScoringDetail_viw.DisplayAnswer} = "Yes")
then 1
else 0

The detail is showing correctly for each row/column. Now, I want to add a calculated column for "Percent of Yes"
= sum(CountofYes) / count of Survey ID

survey 1 survey 2 [Percent of Yes]
Question 1 1 1 2/2 = 100%
Question 2 0 1 1/2 = 50%
Total 1 2 3/4 = 75%



I try for 2 days now and I can't get it to work. Please help! I am using Crystal Report 2008

 

[NickieP]

Try average as your summary not sum