Accumulate
Turns a column of amounts into a running total: each row becomes the sum of everything up to and including that point. This is the node for year-to-date figures and cumulative cash positions.
Inputs
| Input | Accepts | Required |
|---|---|---|
Series | Series (a list of numbers) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Series (a list of numbers) |
Example
A Cash_Flows table holds a monthly Net_Cash_Flow column: 120,000, -45,000, 80,000, -30,000. Wire it into Accumulate and the result is the cumulative cash position: 120,000, 75,000, 155,000, 125,000. Feed that into a line chart with the month column on the horizontal axis and you have a cash runway view; wire the last value into a KPI card via SeriesIndex (index -1) to headline the current position.
Tips
Row order matters: the running total follows the order of the rows it receives. If the source table is not already in date order, put a Sort node in front. Accumulate and Difference are inverses: Difference of a running total recovers the original per-period amounts.