Math operation from text entry piped text | XM Community
Skip to main content
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!
In case someone else in interested, I solved it by dividing it into two parts: !
In your original you needed a space between ( and q AND between 2 and )
Great, thank you TomG!

TomG I don't suppose you happen to know how I could force that calculation to show up with decimals? (Currency)

@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

Dangit, I even saw that part!! Wizard, indeed! You're my hero!! :)

So, I believe that works, however, I need to force a '.00' on whole numbers. Can rounding do that, or do I need something else?

Unfortunately, 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).

TomG Thank you - I've been looking into that, actually, just haven't gotten quite the right syntax. Appreciate your help!!

Leave a Reply


Terms & Conditions