Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

ker0k3n0

Technical User
Apr 19, 2010
18
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top