Convert text to number?

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

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

Thanks.

Couldn’t see it at first!

1 Like

For reference:

Got it