Solved
Round of Score
+5Hi All,
I am trying to round of respondent score using math operations and storing it in embedded data. However export is returning invalid expression.
I have tried couple of things can someone direct me to the error in below math operations :
1. $e{round(gr://SC_06314PNp2z23wah/Score)}
2. $e{round(gr://SC_06314PNp2z23wah/Score,0)}
Regards,
Samarth
Best answer by uhrxx005
If you haven't already, I would take a look here: https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/
Qualtrics requires that you include a space between every item in the equation. That may be why it isn't working. You also need to check the HTML source and make sure its not converting spaces to some weird characters
Here is a formula I recently made and set up to round to 0 decimal places.
$e{ round ( q://QID37/ChoiceTextEntryValue * .05 , 0 ) }
+27Just a guess, but I would try piping the score into an embedded variable first then rounding the embedded variable:
```
roundScore = ${gr://SC_06314PNp2z23wah/Score}
roundScore = $e{ round( e://Field/roundScore , 0 ) }
```
If you haven't already, I would take a look here: https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/
Qualtrics requires that you include a space between every item in the equation. That may be why it isn't working. You also need to check the HTML source and make sure its not converting spaces to some weird characters
Here is a formula I recently made and set up to round to 0 decimal places.
$e{ round ( q://QID37/ChoiceTextEntryValue * .05 , 0 ) }
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.