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

    Weighted Multi-Response Question

    Sindhu Giridharan



      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.