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 )
View original
+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!!
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.