Summary

Computes median or average or sum of a column. Each cell value in the column is expressed in percentage.

Configuration

Name	Value	Opt.	Description	Example
Identifier	System.Object	opt.	Defines which columns should be evaluated as identifiers and separated calculation is carried out based on them. Only taken into account with setting "By column"	col1
Apply to the following columns	System.Double	-	Enter the desired column name, e.g.: A,C-H,K	col1,col2,col3

Name	Value	Opt.	Description	Example
Basis	System.String Median Average Total over all columns/rows Maximum Minimum Maximum-Minimum Rank	-	Select the basis for computation. Each cell value in the column is expressed in percentage of the basis (median or average).	Median
Name of the result column	System.String	-	Input of the name of the result column. Mandatory field!	col3
Use on columns or rows	System.String By column By row	-	Use calculation on columns or rows	By row
Rounding to decimal points	System.Int32	opt.	Rounds the result to the indicated decimal point.	5
Rounding correction to exactly 100 percent	System.Boolean	opt.	Sum of the rounded results must be exactly equal to 100 percent. The rounding will be corrected so that this condition is met. This setting is only valid if 'Sum of the Total Column/Row' is selected as a basis.	-
Name of the results column for base	System.Boolean	opt.	Also output own column with base	-
Name of the result column for base	System.String	opt.	Entry of the name of the result column for base	"col1"
Replace zero value with 0?	System.Boolean	opt.	Should zero values (empty cells) be replaced with 0?	-

This operation can only be performed for columns with numeric values.

	Basis = sum of entire column	Basis = column average	Basis = column median
Operation setting	First, the sum of the column is computed = 44 Then, each individual value is expressed as percentage of this basis. e.g. 10/44 = 0.227..	First, the average of the column is computed = 44 / 5 = 8.8 Then, each individual value is expressed as percentage of this basis. e.g. 10/8,8 = 1.13636	First, the median of the column is computed = 7 Then, each individual value is expressed as percentage of this basis. e.g. 10/7 = 1.42857
Result
TIS Project	Confluence Op As a percentage.gzip