1 2 Previous Next 24 Replies Latest reply on Mar 15, 2016 1:33 PM by Diogo Braga

    SUM IF Responses = "Strongly Agree" "Somewhat Agree" "Agree"

    Diogo Braga

      The data set is from a 6 point Likert scale survey responses.

       

      I have percentages for strongly agree, agree, somewhat agree, somewhat disagree, disagree, and strongly disagree

       

      I need to create a calculated field to calculate the Total Agree.

       

      I unsuccessfully tried...

       

      IF [Response] = "Strongly Agree" "Somewhat Agree" "Agree"

      THEN

      SUM [Response]

      END

       

      Please help!

        1 2 Previous Next