Hi community,
LINKTOROW(ANY(SELECT(Lube Follow up[Unique ID],AND(
[LubePointTask ID]=[_THISROW].[LubePointTask ID],[Status]=โTo doโ))),
โLubricator Details (Route)โ)
That formula does not link to the expected row of Lube Follow up table.
Is there something I missed with that formula?
Thanks for your help
Probably.
It seems that the when the ANY() formula renders blank, the LINKTOROW() formula shows a randomly row of the table. I expected that the LINKTOROW() would just do nothing in that specific case. Could you tell why AS behaves like that?
Thanks
My guess is that โthe quirkโ is biting you:
Indeed, it seems to be something like that!
Thanks Steve!
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |