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