Referencing the previous record/row's value

[prologic]

There needs to be a function or way to reference a record's previous value in the previous row, optionally provide a default or initial value.

Going through the community forum(s) there's a few "solutions" but are honestly a lot of effort for something that in typical spreadsheet-like apps is pretty trivial since you can just reference the first row (with manually inserted data).