Scoring for Muli-Select Questions and Weighted Average Calculations | XM Community
Skip to main content

I am trying to apply advanced survey logic (identifying the max score for a multi-select question and applying custom weighting in order to calculate the weighted average). I tried using embedded data fields within Survey Flow by using piped text to pull the recode values of each selected choice, and then using math operations to determine the maximum and apply weighting. The formula is however not working for me. Not sure if this is the best approach/right approach/i have something wrong with the formula/if this is even something that can be done within Qualtrics?   

Providing an example of one of the formulas I tried to enter in an embedded data field:

$e{max (${q://QID27/SelectedChoicesRecode}) * 30}

Hi ​@Franniem ,

The “max” function is not a valid mathematical operation in Qualtrics, which is why it's not working.
You should use conditional logic to determine the maximum value and then perform the necessary mathematical calculation for weighing.

Hope this resolves your query😊!!