# Math operation from text entry piped text

FlorenceCommunity Member Qubie ✭

# 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!

• Raleigh, NC Wizard ✭✭✭✭✭

In your original you needed a space between ( and q AND between 2 and )

• FlorenceCommunity Member Qubie ✭

In case someone else in interested, I solved it by dividing it into two parts:

• FlorenceCommunity Member Qubie ✭

Great, thank you TomG!

• SLC, UTCommunity Member Qubie ✭

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

• Raleigh, NCCommunity Member Wizard ✭✭✭✭✭
• SLC, UTCommunity Member Qubie ✭

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

• SLC, UTCommunity Member Qubie ✭

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?

• Raleigh, NCCommunity Member Wizard ✭✭✭✭✭

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

• SLC, UTCommunity Member Qubie ✭

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