• Futurama Formulas - Date and time
• Futurama Formulas - Math
• Futurama Formulas - Statistical
• Futurama Formulas - Text
• Futurama Formulas - Logical
• Futurama Formulas - Table
• Futurama Formulas - Document
• Futurama Formulas - Conversion
• Futurama Formulas - Matrix
• Creating custom formulas in Futurama

Module: Editor

Version: 5.1.4 +

Type: Long or Double

Category: Matrix

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:

Column1Column2Column3Column4
2 4
3

Dimension: 2

Result

Matrix:

Column1Column2Column3Column4
2 6 12  20
3 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.