Skip to content
Gallery
Hector's Tips & Experiments
Welcome
Add rows from one table to another
Formula Map
In-line buttons
Random Formula
Accumulated Sum
Timer in a table
BUG: Gravity forms
More
Share
Explore

Accumulated Sum

Problem: I want to have a column with the accumulated revenue per month.
Data
OrderId
Month
Revenue
Accum. Revenue
1
1
Jan 1
$1,000.00
$1,000.00
2
2
Feb 1
$500.00
$1,500.00
3
3
Mar 1
$100.00
$1,600.00
There are no rows in this table
⁠


Solution


Create a “OrderId” column.
Create a new column with the formula: thisTable.Filter(OrderId <= thisRow.OrderId).Revenue.Sum()

Credits: Coda Community
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.