Scoring survey to report total % | XM Community
Skip to main content
Solved

Scoring survey to report total %

  • October 2, 2019
  • 8 replies
  • 71 views

Attempting to have the following data result in a total percentage. I reviewed the math operations page for absolute number and rounding however was not able to get the data to present as a whole number %, it is currently scoring as a decimal. Any help would be much appreciated! " Your score is: $e{ abs ( ${gr://SC_6rOpmJaug8hRJrL/WeightedMean}) } "

Best answer by Akdashboard

Also, if my earlier math operations spits out 86.00%, try the formula below. I haven't been testing this and have only been working off how the math operations SHOULD work. $e{ round( ( round( abs( gr://SC_6rOpmJaug8hRJrL/WeightedMean ), 2 ) ) * 100 ), 0 }%

8 replies

Akdashboard
Level 4 ●●●●
Forum|alt.badge.img+6
  • Level 4 ●●●●
  • 488 replies
  • October 2, 2019
Needs to look like this: $e{ abs ( gr://SC_6rOpmJaug8hRJrL/WeightedMean ) } Notice that i removed ${} from your weightedMean piping and added a space between that and your close ).

  • Author
  • 3 replies
  • October 2, 2019
With those adjustments, it's still showing a total of 0.8666666666666667. Would like to see it report 86% if that is possible or even just 86

Akdashboard
Level 4 ●●●●
Forum|alt.badge.img+6
  • Level 4 ●●●●
  • 488 replies
  • October 2, 2019
You need to add a rounding function to your equation. Everything you need to know can be found on the support page. https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/ Try this: $e{ round( abs( gr://SC_6rOpmJaug8hRJrL/WeightedMean ), 2 ) } that will get you .86. So next, multiple by 100 and add % at the end to get you to 86% $e{ ( round( abs( gr://SC_6rOpmJaug8hRJrL/WeightedMean ), 2 ) ) * 100 }%

  • Author
  • 3 replies
  • October 2, 2019
Thank you for your help! It's at least presenting as a decimal to the nearest tenth now

Akdashboard
Level 4 ●●●●
Forum|alt.badge.img+6
  • Level 4 ●●●●
  • 488 replies
  • October 2, 2019
> @KayciC said: > Thank you for your help! It's at least presenting as a decimal to the nearest tenth now Yeah, I noticed that you wanted a whole number and % at the end and edited my earlier text. The last line should work for you.

Akdashboard
Level 4 ●●●●
Forum|alt.badge.img+6
  • Level 4 ●●●●
  • 488 replies
  • Answer
  • October 2, 2019
Also, if my earlier math operations spits out 86.00%, try the formula below. I haven't been testing this and have only been working off how the math operations SHOULD work. $e{ round( ( round( abs( gr://SC_6rOpmJaug8hRJrL/WeightedMean ), 2 ) ) * 100 ), 0 }%

  • Author
  • 3 replies
  • October 2, 2019
I cannot thank you enough! I played with the coding all morning and couldn't get it right but it works now!

Akdashboard
Level 4 ●●●●
Forum|alt.badge.img+6
  • Level 4 ●●●●
  • 488 replies
  • October 2, 2019
Happy to help 😀