Test is showing a different expression compared to the editor

[GW375]

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?

Thanks!