2 Replies Latest reply on Oct 26, 2017 2:51 PM by Diogo Braga

    Add '1' in front of questions with over 10% of Disagree and Strongly Disagree

    Diogo Braga

      I have a list of survey questions, and I want to put a 1 in front of the ones that have over 10% of Disagree + Strongly Disagree responses.

       

      Refer to Sheet 37 and 38 of the workbook.

       

      So far, I have this calcs:

      Disagree + Strongly Disagree  = SUM(IF [Response] = "Strongly Disagree" OR [Response] = "Disagree" then [Value] END) / SUM([Value])

       

      if [Disagree + Strongly Disagree]>.1 then COUNTD([Question]) else 0 end

       

      This shows the number of questions in each category with over 10% of Disagree + Strongly Disagree responses.

      2017-10-26_1711.png

      The '1' will be added as a new column where you see the red arrow in the screenshot below:

      2017-10-26_1712.png