Calculate the percentage of values based on the sum of all values in that column.

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

Settings

Computes median or average or sum of a column. Each cell value in the column is expressed in percentage. This operation can only be performed for columns with numeric values.

Delete columns
Filter on columns 1.1