Automated decimal places for numeric pipe-in

Question

Dear all,

I've got the following problem: In my questionnaire I ask my participants how much they are willing to pay for a certain product.
In a later question, I ask them to distribute this willingness to pay across different features of the product.
Therefore, I use the answer of the previous numeric question as part of my follow-up question by using a pipe-in. (Remember that you are willing to pay XXX$ ...)

However, the answer to the previous numeric question is always displayed with about 15 decimal places, even though the respondent did not enter any decimal places at all.

(Decimals are/have to be allowed in the previous question about the overall willingness to pay. The issue only appears using the hosting-link but not when testing the survey directly.)

I would be very happy if someone can help me fix this issue!

Thank you in advance!

Kind regards, Seb

Answer 1

Try using the ROUND function which you can find in the SSI Script library.

Example ...

[%ROUND(Q1,2)%]

This will display the number entered at Q1 to 2 decimal places. It will round to the 2nd decimal place which is nice.

Other functions to consider are ...

FORMATNUMBER (NUMBER,"ThousandsSeparator", "DecimalSeparator", NumDecimalPlaces)

ROUNDTONUMBER (NUMBER,ROUNDTO,#DECIMALS)

Comments

Hey Paul,

this worked out well! Thank you!

Kind regards, Seb

---

Awesome Seb. Well done sir.