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 | ![](_scroll_external/attachments/a1f729ad6a17/aspercentage_setting.png)
- 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..
| ![](_scroll_external/attachments/a01312f8cef8/aspercentage_setting2.png)
- 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
| ![](_scroll_external/attachments/ab315c831e46/aspercentage_setting3.png)
- 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 | ![](_scroll_external/attachments/3ef4469d94ff/aspercentage_result1.png)
| ![](_scroll_external/attachments/9b406b44c612/aspercentage_result2.png)
| ![](_scroll_external/attachments/7b480566e127/aspercentage_result3.png)
|
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.