_ColumnCalculations
When an auto total parameter is selected, this parameter can be used to customize the calculation or text that is shown on the total row. By default, all numeric fields, as specified by column types, are totaled. By specifying a comma separated list of calculation requests, the behavior can be modified using special values for the corresponding column.
Type | Result |
|---|---|
sum | Column entries are totaled. The column type must be numeric. |
avg | Column entries are totaled and then divided by the number of data rows. The column type must be numeric. |
avgIgnoreZero | Column entries are totaled and then divided by the number of data rows that are non-zero and non-blank. The column type must be numeric. Requires Table Library 3.5 and above. |
max | The largest data value among the column entries is returned. The Column type must be numeric. |
min | The smallest data value among the column entries is returned. The Column type must be numeric. |
<other text> | Any other text including a blank field will be copied to the corresponding total row field. No calculations are done. |
The Max and Min Total type is available only for Advanced Tables for Confluence: Server and Data Center.
Need support? Create a request with our support team.