Embedded data math operation help | XM Community
Skip to main content
Hello all -



I have a survey that needs a report generated which can display percentages of a total - so, our respondents answer how many students are in a space, the number active, the number active on a playground feature, and the number sedentary. To display this data in my reports-reports, I set embedded data in the survey flow as follows (this is one of three - 'the number active'):



First, I created the variables to give me the 'percent' of how many were active of the total in the pre test and post test:

Percent_Active_PRE = $e{ ( q://QID14/ChoiceTextEntryValue / q://QID13/ChoiceTextEntryValue ) * 100 }

Percent_Active_POST = $e{ ( q://QID33/ChoiceTextEntryValue / q://QID32/ChoiceTextEntryValue ) * 100 }



Then, I created a variable in a separate embedded data box to calculate the difference between the variables I created above:

Percent_Active_Diff = $e{ ( ( q://QID33/ChoiceTextEntryValue / q://QID32/ChoiceTextEntryValue ) - ( q://QID14/ChoiceTextEntryValue / q://QID13/ChoiceTextEntryValue ) ) *100 }



I also created a variable to calculate that same difference in a different way:

EMB_Percent_Active_Diff = $e{ e://Field/Percent_Active_POST - e://Field/Percent_Active_PRE }



However, none of my embedded data is displaying in my report:

!



I'm at a loss - I've checked my math operations, I've cleared my cache and cookies, and nothing works. I've contacted Qualtrics and they have no solution.



I would appreciate any suggestions on what I may be doing wrong or what is happening with my data. Thank you!!



The embedded data in my survey flow:

!
@Liz2006 stupid question. Did you put the embedded data in the very end of the survey flow?



Is it only missing from the reports? Does it show in the Data&Analysis tab?
@Mslreen yes the embedded data is at the end of the survey flow. I only have one block in the survey.



No data displays for these embedded fields in Data&Analysis, either. So that leads me to believe there's something wrong with the math operations in the survey flow, but I can't figure out what.



Thanks for your response.
@Liz2006 You can't have spaces in math operations. Get rid of your spaces and try that 🙂
@Kate - which spaces specifically?



All of the guidance from Qualtrics uses spaces and math operations I've built in other surveys work with spaces. I'm a little confused here...

https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/
Huh- that's weird. All my math equations have no spaces. I had testing issues until I removed all of them. These work for me great.



!
@Liz2006,



They generally look correct to me. In Percent_Active_Diff you are missing a space between the * and 100, and in EMB_Percent_PSactive_Diff you have a double underscore Percent_PSactive_Diff.



I would create a block with a Descriptive Text question where you pipe all the inputs and all the results. Maybe your input pipes are wrong.
@TomG Thanks for catching those typos. I've fixed them, but that still hasn't fixed the issue. I'm really at a loss.



I checked all of the inputs, and they're correct. I've also made sure that all variables were set to number.



Anybody have suggestions for anything else I should double check?
> @Liz2006 said:

> @TomG Thanks for catching those typos. I've fixed them, but that still hasn't fixed the issue. I'm really at a loss.

>

> I checked all of the inputs, and they're correct. I've also made sure that all variables were set to number.

>

> Anybody have suggestions for anything else I should double check?



Make sure QID13 and QID32 aren't zero...that would cause a divide by zero error.
Hi @Liz2006 ! If you have not yet already, we’d recommend reach out to the Support Team, as they are best equipped to troubleshoot and dive deep into this with you!
Thanks, @ChristianB, I actually tried that first and the support person just kept telling me that it was working on their end and they did not offer any solution. That's when I decided to bring it to this forum.

Leave a Reply