How to Perform Math Operations Directly in Embedded Data?

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!