I can’t understand why the following formula doesn’t work
let’s say that I have two tables with 2 columns. First (display) column contains strings. second column of first table contains number. What I want is to filter first table using first column of both tables and obtain the number associated with a name as a result
I have tried both
.lookup(), although I would assume that
lookup would be the advisable option. I also have tried to avoid the comparison between two display columns, copying
Table1.name2. Finally, I have tried to force string conversion to display columns using
Formulas used in
[Table 1].Lookup(name2, thisRow.name1)
[Table 1].filter(name2 = totext(thisRow.name1))
What is wrong with both of them?
Thanks in advance!!!