Convert a Text field to be used in a numeric formula 2

[agreen10]

What is the most efficient way to convert a test field to be used in a calculation. I used:

tonumber ({Field1}) and I keep getting an error in the evaulation formula that says it is non-numeric.

 

[lbass]

Please supply some samples of the field that show the possible variations. If the number you want is always leading, then you could use:

val({table.string})

If the first character is not a number, this formula will return a zero and would not pick up subsequent numbers.

-LB

 

[agreen10]

I have two fields that hold scores. I need to use those scores in calculations, however, they are designed as strings. I tried to use a formula to convert them using "tonumber" but when I actually use them in a formula, I keep getting "the string is non-numeric". eg

{grade} - {score_1} where score_1 is the formula "tonumber({score})".

I hope this helps clarify what I am doing.

 

[ianoctdec]

What about testing the string field for numeric first:
if isnumeric(trim(({score}) then
tonumber({score})
else
0

Daniela

 

[synapsevampire]

As Daniela's formula demonstrates, you DON'T have numerics in all of them.

You can demonstrate the non-numerics by putting the following in the Report->Selection Formulas->Record:

not(isnumeric({score}))

Then place the {score} field in the details and you'll discover the offending fields.

-k