Report showing percentage of respondents who answer YES 1

[MrBubbles]

My SQL table has 25 fields - Q1, Q2, Q3, etc. each field representing a question on a customer service survey. The field is populated with either a 'Yes' or 'No'.

I normally group these reports by locationcode (a field) and then by associate (LastRSA).

I would like to create a report that says (literally) 29% of our customers answered 'Yes' 71% answered 'No'.

I just can't get my brain around this - can anyone help?

 

[Turkbear]

Hi,
One way:
Create formulas to check the answer and then set a value to 1 or 0.
Sum these Yes/No numbers and compute the % of each:

Example( very rough):
@Q4Y
If {Q4} = 'Yes' then 1 else 0
@Q4N
If {Q4} = 'No' then 1 else 0

@PctyesQ4( in Group or Report footer)
(Sum(Q4Y)/(Sum(@Q4Y) + Sum(@Q4N))) * 100 ( or format as %)




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MrBubbles]

I can't seem to get the correct ( ) or { } correct in the PctyesQ4 formula...

The @Q4Y and @Q4N I understand exactly...

When I double click the formula fields to insert them into the last formula Crystal places the {} around the formula names and I am getting them confused with your ()... would you mind helping again?

 

[Turkbear]

Hi,
Ok, I'll try:

@PctyesQ4( in Group or Report footer)
(
Sum(@Q4Y)/(Sum(@Q4Y) + Sum(@Q4N))
) * 100

The Sum(@Q4Y) ( and Sum@Q4N) ) are exemplars..Have Crystal Insert Summaries for each and use those 'actual' summaries,
which Crystal will name, in place of my symbolic ones..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MrBubbles]

I figured it out... I created the Y and N fields, sum'd them in the group footer, then created the Pct sum field with the sum'd fields crystal created...

Got it... Great... Thank you!


Peace