Round of Score

SamarthSamarth INDIACommunity Member - Trial User Guru ✭✭

Round of Score

Hi 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)}


Best Answers

  • TomGTomG Raleigh, NC Wizard ✭✭✭✭✭
    Accepted Answer

    Just 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 ) }
  • uhrxx005uhrxx005 Guru ✭✭
    edited March 2018 Accepted Answer

    If you haven't already, I would take a look here:

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


  • SamarthSamarth INDIACommunity Member - Trial User Guru ✭✭

    Hi Guys,

    Many thanks for the help!

    @TomG it worked however I have used approach suggested by @uhrxx005 since it lets me do have just one variable instead of creating two.

    @uhrxx005 many thanks for the tip :smile:


Sign In to Comment