Convert text to number?

PocketSurvey · 08-13-2020 02:45 PM

How do you convert a text field to a number so you can do calculations on it?

I’ve had to use ANY and SELECT to match on multiple columns to retrieve a value byt unfortunately this comes out as a text value not a number.

The value amityville in is a number.

Alternatively does anybody know how to use lookup to be able to match on multiple columns not just one

Summer1

number([column name])
number("100")

PocketSurvey

Thanks.

Couldn’t see it at first!

Steve

For reference:

AlfredoChavez

How do I do it when the number is less than 12? It gets confused with a moth

Steve

Please post a screenshot of the entire expression that doesn't work as desired.

PocketSurvey

Got it

KamolDip

How you solved it?

JimandToby

Please can I resurrect this question.

I am hoping to turn text into an numeric amoubt but I'm really struggling to get any answers.

Eg. Apple = 10, orange =20.

So the user selects apple.

They get the answer = 10.

Many thanks @Steve