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
If you use SELECT instead you’ll get a list of values. MAXROW can be used to get the greatest value from that list.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |