How can I accept a Currency Formatted input and then do math on it? | XM Community
Skip to main content
Question

How can I accept a Currency Formatted input and then do math on it?

  • July 2, 2021
  • 3 replies
  • 319 views
mklubeck
Level 3 ●●●
Forum|alt.badge.img+8

Qualtrics requires inputs to be numeric-only - not allowing "$" or "," (it accepts decimals). And a lot of times we want to accept inputs that are currency. Respondents want to see the $ and the "," between 1 and all those zeroes. But Qualtrics can't do mathematical calculations on those type of data.
Best case scenario would be to have the $ auto show up as the person types in the amount, and appropriate commas also auto entry...basically using a Currency Format. BUT then allow mathematical operations on it. Happy to have a way to create an Embedded Data variable that holds only the numerical representation and use that for the math.

Abhishek_U

3 replies

grahulp5
QPN Level 3 ●●●
Forum|alt.badge.img+13
  • grahulp5
  • QPN Level 3 ●●●
  • July 12, 2021

The best way would be to parseInt the string or maybe get the value in survey flow in numeric form and then perform the arithmetic operation. Or you can just create a function to add ',' in real time and then on pagesubmit to parseInt the value to number.

mklubeck
Level 3 ●●●
Forum|alt.badge.img+8
  • mklubeck
  • Author
  • Level 3 ●●●
  • July 13, 2021

grahulp5 Thanks, but I have no idea what you mean. "just create a function", "pagesubmit", and "parseInt the value to number" sound very techno but I can't put any of that into action to solve the problem.
t

A
grahulp5
QPN Level 3 ●●●
Forum|alt.badge.img+13
  • grahulp5
  • QPN Level 3 ●●●
  • July 13, 2021

Just select the text entry type question with a label and do the math operation in JS section. or if it's not important to be a text entry then just give the option as a single punch if the list is not long.

Terms & ConditionsAccessibility statement