I cannot find what I am missing with this lookup function to return an empty result. The select works as shown.
LOOKUP(ANY(SELECT(Devis[ID Adresse],[ID Devis]=[_THISROW].[ID Devis])),“Adresse”,“ID Adresse”,“Rabais”)
Any eye opening tip would be appreciated!
The issue likely comes from ANY(SELECT(…)) returning NULL or an unexpected value that does not match any row in the “Adresse” table.
any way It is better to put forward what you want to do so that we can help you
Hey @AbdullaNsour ,
Thanks for taking the time to look at my issue!
On the top right corner of the image, you can see the result of the ANY(SELECT()) returning the ID value (not NULL) used in the LOOKUP().
I don’t see anything wrong; it just seems unusual.
In such cases, I usually break the problem down into multiple Virtual Columns, isolating each part of the expression to pinpoint the issue.
Thanks for your persistence @AbdullaNsour !
Assuming ANY(SELECT()) works as shown, how do you suggest to break down LOOKUP()?
Well, it appears this issue is gone. Not clue on what happened.
