How to create embedded data? (math operation - round number) | XM Community
Skip to main content


Hello all,

I would like to measure how much people are willing to spend and give choice options that are 10%, 20%, 30% higher than their answers.
For example, if someone says he's willing to spend '$40', then on the next page, he will be given '$44', '$48', '$52', '$56'
Capture.PNG
I also would like to round the numbers just in case. (Ex. $45 => $50(from 49.5), $54).
Here is the embedded data that I create for 10% above option and it displays nothing in the preview.
Capture2.PNG
Do you have any idea how to fix it?
Thanks in advance



Hi S_smith
Could you please check the survey flow and the placement of these embedded variables? By looking at the questions screen capture it seems both the questions are in same block and calculations is done after or before the block because of which you are not able to piped text/calculate the values in question text.
Also correct the math operations for 10above using this link.

The issue is that you are not referencing the embedded data 

Q111
. Qualtrics is interpreting your code literally and multiplying Q111 with 1.1, which throws an error. Hence, 
10above
is empty.
These two should produce the same results:
  1. $e{ round( q://QID1/TotalSum * 1.1 ) }

  2. $e{ round( e://Field/Q111 * 1.1 ) }

You can find the syntax here

Thank you both!! I've solved the issue 🙂

Leave a Reply


Terms & Conditions