Colum does not have valid input types when using lookup to find approximate match

[Marcelkrush]

Hello goodnight. I have a table with the latitudes and the names of the regions. In one form, one column records the Latlong of the start of the trip, from which the latitude value is extracted for another column in the same form. This column that receives the latitude value performs a search as if it were Excel's vertical lookup and should return the name of the region according to latitude. As trips can start at any latitude value and latitude value must be recorded at the time of the start of the trip and it would be impractical to put all the latlongs of all possible embarkation points in a table, I need Search for to return the approximate match, even because, I only need the region names and not the full addresses. The problem is that it is returning the message "'([COLUMN WITH LATITUDE VALUE] >= [Latitude])' does not have valid input types" . Could someone help me figure out what I'm doing wrong? The expression used is attached. LOOKUP( ANY( ORDERBY( FILTER( "Locations", ([COLUMN WITH LATITUDE VALUE] >= [Latitude]) ), [Latitude], TRUE ) ), "Locations", "Latitude", "Region" )

[dbaum]

---

@Marcelkrush wrote:

The problem is that it is returning the message "'([COLUMN WITH LATITUDE VALUE] >= [Latitude])' does not have valid input types"

---

Confirm the Column data types for each of the columns in that part of your expression. You may need to convert one or both to another data type--e.g., using the DECIMAL() function.

[Steve · Accepted solution]

Instead of:

([COLUMN WITH LATITUDE VALUE] >= [Latitude])

Try:

([_THISROW].[COLUMN WITH LATITUDE VALUE] >= [Latitude])

Or:

([COLUMN WITH LATITUDE VALUE] >= [_THISROW].[Latitude])