4 Replies Latest reply on May 19, 2016 5:04 PM by Susan Baier

    Exclude responses with certain measure value from calculation

    Susan Baier

      I'm struggling with a calculation to determine the percentage of respondents who rated an item with a 6 or 7 on a 7-point scale (Top 2 Box) IF a response of "8" indicated they were unable to rate the item.

       

      My typical calculation for % Top 2 Box is this:

       

      SUM(

          IF [Value]>=6 then 1 ELSE 0 END

          )

      / SUM([Number of Records])

       

      I can't figure out how to exclude responses with an "8" from this calculation, so that the percentage calculated is among only those who didn't rate it an "8".

       

      Thanks in advance for the help!