Module: Editor
Version: 5.1.4 +
Description
The formula 'Cumulative' returns a cumulative matrix over a specified dimension. A cumulative is the sum of each number in the matrix from left to right or top to bottom. The function 'Cumulative' creates a new matrix with the same amount of rows and columns as the matrix used for the input, but with the cumulatives.
Parameters
Matrix: the matrix you want to accumulate.
Dimension: the dimension to accumulate. 1 means downwards (over rows), 2 means rightwards (over columns).
Example
Description
In the following example the formula 'Cumulative' is used to accumulate a matrix over dimension 2 (over columns).
Values parameters
Matrix:
| Column1 | Column2 | Column3 | Column4 |
|---|
| 2 |
4 |
6 |
8 |
| 3 |
5 |
7 |
9 |
Dimension: 2
Result
Matrix:
| Column1 | Column2 | Column3 | Column4 |
|---|
| 2 |
6 |
12 |
20 |
| 3 |
8 |
15 |
24 |
The result is a matrix with cumulatives. In the most right column are the total sums of the rows.
Related Topics
- CumulativeProductMatrix : The formula 'CumulativeProductMatrix' returns a cumulative product matrix over a specified dimension.
Feedback
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.