Hello, 

another way to cover it can be using JS script in the question after your grid question ?

regards

Hi Phillip,
I have “similar” calculations in my survey. One way to realise those “complex” calculations is to use JavaScript.

The JavaScript has to sit in one of the questions AFTER your last statement block. This makes sure that you can access all statement results (e.g. their recoded values, as in my example) via variables.

Here’s a snippet of how my code looks like. I guess you should be able to adapt it to your needs, even without big coding skills.

Qualtrics.SurveyEngine.addOnReady(function()
{
    /* Defining a function that does all the required calculation */
	const score = function(per, pre) {
		var result = "";

		per = Number(per);
		pre = Number(pre);

		if (per != 99 && pre != 99) {
			result = (25 * (per + pre)) - 100;
		} else if (per == 99 && pre == 5) {
			result = (25 * (5 + 5)) - 100;
		} else if (per == 99 && pre < 5) {
			result = (25 * ((pre / 0.9) + pre)) - 100;
		} else if (per == 1 && pre == 99) {
			result = (25 * (1 + 1)) - 100;
		} else if (per > 1 && per != 99 && pre == 99) {
			result = (25 * (per + (per * 0.9))) - 100;
		}

		return result;
	};


	/* Getting the answers of previous questions */
    var perf = "${q://QID7/SelectedChoicesRecode}";
	var pref = "${q://QID8/SelectedChoicesRecode}";

    /* Calling the above specified function with all calculations */ 
	var score_Comp = score(perf, pref);

    /* Writing result out to Embedded data */
	Qualtrics.SurveyEngine.setEmbeddedData( 'Score_Company', score_Comp );	


});

Best,

Manfred

To put this in place with JavaScript, first create an Embedded Data variable at the top of the Survey Flow called 'average'. Then, add the below JavaScript to the OnReady section of any question that comes on a page after the Matrix question, updating the QID to match the Matrix question:

var choices = "${q://QID1/ChoiceGroup/SelectedChoices}";
var choicesnumber = choices.split(",").length;
console.log(choicesnumber);

var recode1 = "${q://QID1/SelectedAnswerRecode/1}";
var recode2 = "${q://QID1/SelectedAnswerRecode/2}";
var recode3 = "${q://QID1/SelectedAnswerRecode/3}";
var recode4 = "${q://QID1/SelectedAnswerRecode/4}";
var recode5 = "${q://QID1/SelectedAnswerRecode/5}";
var recode6 = "${q://QID1/SelectedAnswerRecode/6}";
var recode7 = "${q://QID1/SelectedAnswerRecode/7}";

recode1 = +recode1 || 0;
recode2 = +recode2 || 0;
recode3 = +recode3 || 0;
recode4 = +recode4 || 0;
recode5 = +recode5 || 0;
recode6 = +recode6 || 0;
recode7 = +recode7 || 0;

var total = recode1+recode2+recode3+recode4+recode5+recode6+recode7;
console.log(total);

var average = total / choicesnumber;
console.log(average);

Qualtrics.SurveyEngine.setEmbeddedData('average',average);

We can even use Scoring and then pipe ‘WeightedMean’ to an embedded data to get actual score.

Hi @Phillip85 ,

Please use Qualtrics inbuilt scoring option (Link added here https://www.qualtrics.com/support/survey-platform/survey-module/survey-tools/scoring/)

In Survey flow, you can then add embedded field to calculate value you are looking for. Link for more details https://www.qualtrics.com/support/survey-platform/common-use-cases-rc/displaying-messages-based-on-scoring/

Thanks,

JB

var choices = "${q://QID1/ChoiceGroup/SelectedChoices}";
var choicesnumber = choices.split(",").length;
console.log(choicesnumber);

var recode1 = "${q://QID1/SelectedAnswerRecode/1}";
var recode2 = "${q://QID1/SelectedAnswerRecode/2}";
var recode3 = "${q://QID1/SelectedAnswerRecode/3}";
var recode4 = "${q://QID1/SelectedAnswerRecode/4}";
var recode5 = "${q://QID1/SelectedAnswerRecode/5}";
var recode6 = "${q://QID1/SelectedAnswerRecode/6}";
var recode7 = "${q://QID1/SelectedAnswerRecode/7}";

recode1 = +recode1 || 0;
recode2 = +recode2 || 0;
recode3 = +recode3 || 0;
recode4 = +recode4 || 0;
recode5 = +recode5 || 0;
recode6 = +recode6 || 0;
recode7 = +recode7 || 0;

var total = recode1+recode2+recode3+recode4+recode5+recode6+recode7;
console.log(total);

var average = total / choicesnumber;
console.log(average);

Qualtrics.SurveyEngine.setEmbeddedData('average',average);

Thank you so much, this solution worked!