R.CUMULATIVE

This function is used to get the cumulative value.

Syntax

R.CUMULATIVE(ValueCell, [ContextCell1], [ContextCell2])

Arguments

This function has the following arguments.

Argument	Description
ValueCell	[Required] Specify the cell for which you want to get the cumulative value.
ContextCell1	[Optional] Specify context cell 1, which usually is the year cell. Example: If the A2 cell is bound to the year column, the B2 cell is bound to the month column, C2 cell is bound to the sales column, then the result is as follows: R.CUMULATIVE(C2) will return the cumulative value of sales for the entire period. R.CUMULATIVE(C2, A2) will return the cumulative value of sales for the current year.
ContextCell2	[Optional] Specify the context cell 2. If the value cell is a cross cell, this argument must be specified.

Argument

Description

ValueCell

[Required] Specify the cell for which you want to get the cumulative value.

ContextCell1

[Optional] Specify context cell 1, which usually is the year cell.

Example:

If the A2 cell is bound to the year column, the B2 cell is bound to the month column, C2 cell is bound to the sales column, then the result is as follows:

R.CUMULATIVE(C2) will return the cumulative value of sales for the entire period.
R.CUMULATIVE(C2, A2) will return the cumulative value of sales for the current year.

ContextCell2

[Optional] Specify the context cell 2.

If the value cell is a cross cell, this argument must be specified.

Example 1: The value cell is a normal cell

Template:

RS-TemplateNormalCell

Preview:

RS-ReportNormalCell

Example 2: The value cell is a cross-cell

Template:

RS-TemplateCrossCell

Preview:

RS-ReportCrossCell