Creating a Column with a Running Total from multiple records

[Ann_Myers]

I am trying to create a column with a running total when a new amount is added to the first column. For example, if I were to enter $100 in one record and $200 for a second record, I want a second column to show a total of $300. Can someone assist with a formula? Thank you.

[Justin_Barrett]

It’s not as simple as a single formula, I’m afraid. More here, including details on how to set up a solution:

Multi-record calculations (c.f. 'running balance,' 'row number,' and the like) Show and tell

tl;dr version: A frequent query and/or complaint concerns users who wish to access data from a record for use in a calculation performed in a different record from the same table. Often this takes the form of a user asking ‘how to retrieve a value based on row number’; other times the user wishes to perform a calculation that assumes knowledge of the previous record — for instance, maintaining a running balance. A recently published base contains four approaches to this problem, three involving …