1 Reply Latest reply on Oct 28, 2013 5:37 AM by Shawn Wallwork

    Create a Survey Report

    Cosimo De Candia

      Hi,

      I want to create a Survey Report.

      For Example:

      Question_id1345611..16_1
      106365566511

      In this case I have some question single and some multiple.

      Question_id1,3...6 are single(value Answer) while

      Question 11 is single (code Yes=1 No=2 else 3)

      Question_16 is multiple question ( I can find 2 3 4 row for this question)

       

      I have create 2 Calculate Field.

      q1 (if [Question ID]="1" then [Answer] else "0" end) In this case have 2 result (0 and 4 or 5 Why???)

      q16(if [Question ID]="16" and [Answer]="Email from pippo" then "1" else "0" end) In this case have 2 result when it's ok Why??

       

      There are csv and twb in attach

       

       

      Thanks in advance,

      Cosimo