Summary

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

Example: Calculating different percentages

 

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

 

Want to learn more?

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.

Columns of input table



Parameter



Troubleshooting

nothing known yet

 

Related topics