3 Replies Latest reply on Mar 24, 2017 12:47 PM by Michael Someck

    Weighted Multi-Response Question

    Sindhu Giridharan

      Hello!

       

      I have a data set that has been re-shaped with the following columns:

       

      Username - Weight - Question - Response

       

      For a question that has multiple responses, I'd like to calculate the Weighted Sum of the Response.

      I've used SUM(IIF([Response] != 'null',[Weight],0)), but my results do not tally with manual excel calculations.

       

      Can anyone help me with where I am going wrong?

      Attached is a sample excel sheet for reference.

       

      Thanks!