How do I reference the value of the previous row?

I am creating a weight recording application.
I want to use a virtual column to find the increase/decrease value from the previous record, but it doesn’t work.

LOOKUP([_ROWNUMBER]-1, “log”, “_ROWNUMBER”, “weight”)

I tried the above formula, but it didn’t work.

Try this:

LOOKUP([_THISROW].[_RowNumber]-1, “log”, “_RowNumber”, “weight”)

2 Likes

Wow!
It worked.
Thank you!

1 Like

Welcome!