R.PROPORTION

This function is used to get the proportion of cell values.

Syntax

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

This function has the following arguments.

Argument	Description
ValueCell	[Required] Specify the cell for which value you want to get the proportion.
ContextCell1	[Optional] Specify context cell 1, which usually is the year cell. Example: If the A2 cell is bound to the year column, B2 cell is bound to the month column, C2 cell is bound to the sales column, then, R.PROPORTION(C2) will return the current sales proportion in all years' sales. R.PROPORTION(C2, A2) will return the current sales proportion in current year sales.
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 value you want to get the proportion.

ContextCell1

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

Example:

If the A2 cell is bound to the year column, B2 cell is bound to the month column, C2 cell is bound to the sales column, then,

R.PROPORTION(C2) will return the current sales proportion in all years' sales.
R.PROPORTION(C2, A2) will return the current sales proportion in current year sales.

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-PROPORTION-normalCellTemplate

Preview:

RS-PROPORTION-normalCellReport

Example 2: The value cell is a cross cell

Template:

RS-PROPORTION-crossCellTemplate

Preview:

RS-PROPORTION-crossCellReport