RE: Embedded Data / Piping Problem - providing too many numbes | XM Community
Skip to main content
Question

RE: Embedded Data / Piping Problem - providing too many numbes

  • March 12, 2024
  • 3 replies
  • 42 views

Forum|alt.badge.img+1

Hi All,

 

In my “triggered email” response to assessment respondents, I’d like to reduce the number of decimals to no more than two. I imagine this is a common problem, I just can’t seem to find a solution on youtube or Qualtrics.

 

This is an example of what the embedded data is spitting out when I pipe in the data to the respondent:

Product Positioning: 2.875

Company Culture: 4.25

Leadership Quality: 1.2

Role Alignment: 1.1428571428571

Company Culture: 1.1818181818182

 

Any help here would be greatly appreciated!

3 replies

Shashi
Level 8 ●●●●●●●●
Forum|alt.badge.img+34
  • Level 8 ●●●●●●●●
  • 654 replies
  • March 12, 2024

Use Math operation round operation.


Forum|alt.badge.img+1
  • Author
  • 1 reply
  • March 12, 2024

Thanks Shashi. 

 

For others that may know the solution, I’m using this operation to round to two decimal points but there’s something wrong with the equation. Would you mind reviewing this and let me know what I’m doing wrong?

Current readout from piped input: 

  1. Role Design and Alignment: 3.7857142857143

Equation I’m using: ${round (gr://SC_bC2HwMoMwBF73aC/WeightedMean}, 2)}


Shashi
Level 8 ●●●●●●●●
Forum|alt.badge.img+34
  • Level 8 ●●●●●●●●
  • 654 replies
  • March 12, 2024

 

Thanks Shashi.  I’m using this operation to round to two decimal points but there’s something wrong with the equation. Would you mind reviewing this and let me know what I’m doing wrong?

${round (gr://SC_bC2HwMoMwBF73aC/WeightedMean}, 2)}

Try this:

$e{ round( gr://SC_bC2HwMoMwBF73aC/WeightedMean , 2 ) }