• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL Command Executor Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# mcumsum()

Description:

Perform cumulative sum on a matrix or a multidimensional matrix.

Syntax:

mcumsum(A, n)

Note:

In the external library function , parameter n is the ordinal number of dimension level where summarization is performed. If n is absent, the desired dimension is the first one whose size is not 1 in matrix A.

Parameter:

 A A matix or a multidimensional matrix n A positive integer

Option:

 @z Perform inverse cumulative sum

Return value:

A sequence

Example:

A

1

[[11,12,13],[21,22,23],[31,32,33]] 2

=mcumsum(A1,1) Perform cumulative sum on the first level of A1’s matrix – that is, sum members of each column

3

=mcumsum(A1, 2) Perform cumulative sum on the second level of A1’s matrix – that is, sum members of each row

4

=mcumsum(A1) Perform cumulative sum on the first level as parameter n is absent

5

=mcumsum@z(A1) Perform inverse cumulative sum

6

[[[111,112,113],[121,122,123],[131,132,133]],[[211,212,213],[221,222,223],[231,232,233]]] Define a three-dimension matrix whose two members are 3*3 matrices

7

=mcumsum(A6, 1) Calculate cumulative sum on matrix A6’s first level, that is, perform the calculation on both of its two member matrices in alignment

8

=mcumsum(A6, 2)

Calculate cumulative sum on matrix A6’s second level, that is, perform the calculation on each column of each member matrix 