Converting text field numeric value for use in calculation

Follow

Karl Nazer

• March 30, 2015 09:23

Is there some way we can parse a input txt field to output a number?
everything we have tried is still returning the result as a string.
we have checked we are first saving the calculation field as a number field.

The following all fail to achieve what we're after. The calculation will fail with "The result is not a valid number".

parseFloat(text_field)
parseInt(text_field)
Number(text_field)
text_field / 1
text_field + 0
etc

0

• 

  James Bowie

  • August 25, 2015 01:34

  +1

  In my case I'm using a text field so that I can express a percentage as X%, but want to be able to multiply a number field and a text field for a calculation like this:

  @dollar_amount * @text_%_field = new value amount

  0

  Comment actions Permalink

Please sign in to leave a comment.