Running Total of number in rows

[sheinrich]

I would like to create a running total in a table.
There is a column called “Duration in minutes.” In a formula, all values from the rows above should be added.
As a selection criterion, the column “Order number” can be used: all values in the “Duration in minutes” column should be summed from the rows where the order number is lower than the order number in the current row.

Your Setup:

• SeaTable Cloud, Dedicated or Self-hosted?
• SeaTable Version (only necessary for self-hosted):
  You can find your SeaTable Server version at https://your-server-url/server-info

Describe the Problem/Error/Question:

Please describe your issue as precise as possible. If helpful, you can also provide:

• Your formula (wrapped as code block)
• Screenshots
• Diagrams with Excalidraw
• Base structure details using this script.

Error Messages:

If there are any error messages shown in the browser console, please include them for better readability by wrapping them in a code block.

Example of a code block for error messages

[Soonimproveduser]

Try a second table containing the orders only and sum them there

[rdb]

You can use the data processing operation “Calculate sum”