How to create a formula to show accumulated amount per account

Ask for Help
11

As of a few months ago, Grist has a much better way of doing this: the PREVIOUS function.

Unlike the previously-proposed workaround, no need for helper columns in summary tables to create helper data structures. You can create a “Previous” column like so:

PREVIOUS(rec, group_by="Account", order_by="Date")

And use it to calculate cumulative values, e.g. in a column named “Cumulative”:

($Previous.Cumulative or 0) + $Amount