There was a post about a similar problem back in April 2020, but my issue is a little different.
I have the following expression in the editor:
I thought this would give me a list of the Top 5 [TotalWeight] based a specific TripID referenced. The expression editor gives the green light.
When I go to test, I get the following result:
It is giving me a list of weights, but from [_THISROW-1].[TripID] and not from [_THISROW].[TripID] as in the expression editor. The weights are from the previous trip and not the current trip.
Am I doing something wrong? Is this a bug?