Can't seem to filter out current row from filtered list

I am using this equation to attempt to select the items that has the same [order by] column value but is not [_thisrow].

FILTER(
“MATERIALS”,
AND(
[ORDER BY] = [_THISROW].[ORDER BY],
[KEY] <> [_THISROW].[KEY]
)
)

When running this through a test, I am seeing that [_thisrow] is still being added to the filtered list. I cannot seem to figure out why this is as everything seems correct in the logic of the equation. Does anyone know what probably obvious thing I am skipping over here?

2022-01-12 11-54-20 (1)

Try with removing this:

image

[_THISROW] already is the key value of the row, you don’t need to dereference any further.

2 Likes

Thanks @Marc_Dillon I just discovered my actual problem. I had a different problem that lead me to start testing this equation. I was forgetting that during a test like this, there isn’t any thing to reference in [_thisrow]. I got caught up in this confusion but I have now fixed my real issue. Mixed up actions in a group action trigger. Haha

3 Likes