Hi I’m using the LOOKUP expression to find a value in another table. The problem is there are more than one possible result in the other table so Appsheet randomly selects one of the possible values. How can I force it to select a particular value e.g the largest value? Thanks
Elize_de_Beer (Elize de Beer) #1
Gil_Littman_AppSheet (Gil Littman [AppSheet]) #2
If you use SELECT instead you’ll get a list of values. MAXROW can be used to get the greatest value from that list.