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?
Solved! Go to Solution.
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
Try with removing this:
[_THISROW] already is the key value of the row, you donโt need to dereference any further.
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
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |