Creating a piped text / embedded data formula | XM Community
Skip to main content
Solved

Creating a piped text / embedded data formula

  • August 28, 2021
  • 2 replies
  • 93 views

Forum|alt.badge.img+5

Hello,
I wanted to create a formula in order to later use the data + show the results at the end of the survey for my participants, but for some reason I can't get it right.
I need to subtract one factor from the other and my questionnaire is in Hebrew so I created a few versions of the formula just to make sure what is the right combination.
Those are my factors:
co - ${gr://SC_cLPINbSIeRMxeNE/WeightedMean}
mrat - ${gr://SC_8uoMmrrJSO1RLls/WeightedMean}
I would like to substract mrat from co (co - mrat), so those are the versions I created by neither is working.
$e{ gr://SC_cLPINbSIeRMxeNE/WeightedMean - gr://SC_8uoMmrrJSO1RLls/WeightedMean }
{ gr://SC_cLPINbSIeRMxeNE/WeightedMean - gr://SC_8uoMmrrJSO1RLls/WeightedMean }#$
$e{ gr://SC_cLPINbSIeRMxeNE/WeightedMean - gr://SC_8uoMmrrJSO1RLls/WeightedMean }
{ gr://SC_cLPINbSIeRMxeNE/WeightedMean - gr://SC_8uoMmrrJSO1RLls/WeightedMean​​​​​​​ }#$
${gr://SC_8uoMmrrJSO1RLls/WeightedMean}
${gr://SC_cLPINbSIeRMxeNE/WeightedMean}

Does anyone know how to fix it?
Have a good weekend,

Daniel

Best answer by DanielSpitz

Yes, I did that.
The problem was in the equation itself.
Thankfully I was able to solve it with the help of the support. We simply put the equation as embedded data and then displayed it as piped text.

2 replies

MSobotta
Level 4 ●●●●
Forum|alt.badge.img+25
  • Level 4 ●●●●
  • September 2, 2021

Are they initialized as numbers? I would try to store them as new embedded data.
I would also try to first make sure your embedded data is stored correctly by using a piped text to display them in a Text/Graphic question.


Forum|alt.badge.img+5
  • Author
  • Level 1 ●
  • Answer
  • September 2, 2021

Yes, I did that.
The problem was in the equation itself.
Thankfully I was able to solve it with the help of the support. We simply put the equation as embedded data and then displayed it as piped text.