Apparently the expression is not correct. When I write :
${e://Field/average} , I get {Invalid Expression}.
I followed the "Math Operations" page provided in Qualtrics to write the embedded data expression. What am I doing wrong?
Thank!
Solved
Math operation from text entry piped text
Hi all, I have a matrix question, with one row and two columns, with a text entry form. In each of the columns I ask the responded to give a number (I set Content Validation --> Number).
I want to calculate the average of these two text entries. In the Survey flow, after the block where I ask them about these two numbers, I write:
!
Apparently the expression is not correct. When I write :
${e://Field/average} , I get {Invalid Expression}.
I followed the "Math Operations" page provided in Qualtrics to write the embedded data expression. What am I doing wrong?
Thank!
Apparently the expression is not correct. When I write :
${e://Field/average} , I get {Invalid Expression}.
I followed the "Math Operations" page provided in Qualtrics to write the embedded data expression. What am I doing wrong?
Thank!Best answer by TomG
In your original you needed a space between ( and q AND between 2 and )
+27In your original you needed a space between ( and q AND between 2 and )
+9TomG I don't suppose you happen to know how I could force that calculation to show up with decimals? (Currency)
+27@KWigg,
You can use the round function in an expression: https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/#AvailableOperations
+9Dangit, I even saw that part!! Wizard, indeed! You're my hero!! :)
+9So, I believe that works, however, I need to force a '.00' on whole numbers. Can rounding do that, or do I need something else?
+27Unfortunately, there isn't a practical survey flow method of formatting numeric embedded variables. So, you'll have to do it in JavaScript with .toFixed(2).
+9TomG Thank you - I've been looking into that, actually, just haven't gotten quite the right syntax. Appreciate your help!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.