Hi all,I'm working on a survey where I need to calculate the sum of three numeric values entered in a matrix question and store the result in an embedded data field. Here's the scenario:The matrix question ID is QID16, and I want to sum the numeric entry values from: Row 12, Column 1: ${q://QID16/ChoiceNumericEntryValue/12/1} Row 17, Column 1: ${q://QID16/ChoiceNumericEntryValue/17/1} Row 18, Column 1: ${q://QID16/ChoiceNumericEntryValue/18/1} I've added an embedded data field named Q11_Total in the Survey Flow, where I'm using the following formula:Q11_Total = ${q://QID16/ChoiceNumericEntryValue/12/1} + ${q://QID16/ChoiceNumericEntryValue/17/1} + ${q://QID16/ChoiceNumericEntryValue/18/1}However, the result always shows 0 in the embedded data field, even when valid values are entered in the matrix question.Could anyone help me identify what I might be doing wrong? Is there a specific format I need to follow, or do I need to enable something else for this to work?Thanks in advance for your guidance!

Ensure the QID you are mentioning is in number not in text. If possible please show the QID16 is displaying.Also Syntax is incorrect. Check the syntax, ensure you make necessary changeshttps://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/

How to Perform Math Operations Directly in Embedded Data?

How to Perform Math Operations Directly in Embedded Data? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded