Summarizing Actions
PrevIntroduction
The summarizing actions are used by following functions:
Overview of Available Consolidation Actions
The summarizig actions define the calculations to be applied to condense the base data in the iput table and provide summarized values in pivot tables.
Both numeric (e.g. counting, adding) and string functions (e.g. alphabetic minimum and maximum) are provided.
Note: Numbers, as described below, refer to integers, real numbers and numbers with scientfic notation, both positive and negative.
Calculated values are not stored back using scientific notation but as real numbers.
| Summarizing Action | Description |
|---|---|
| sum | Sums all non-blank values. Blank values are ignored. All non-numeric values are treated as 0. |
| sum numbers | Sums all numbers. Blank and non-numeric values are ignored, even though the result is the same sum as above. |
| sum ignore zero | Sums all non-zero numbers. 0 are ignored, even though the result is the same as above. |
| min | Finds the lowest number. Blank values are ignored. All non-numeric values are treated as 0. |
| min numbers | Finds the lowest number. Blank and non-numeric values are ignored. |
| min ignore zero | Finds the lowest non-zero number, ignoring 0 and non-numeric values. |
| max | Finds the highest number. Blank values are ignored. All non-numeric values are treated as 0. |
| max numbers | Finds the highest number. Blank and non-numeric values are ignored. |
| max ignore zero | Finds the highest non-zero number, ignoring 0 and non-numeric values. |
| product | Multiplies all non-blank contents. Blank values are ignored. All non-numeric values are treated as 0, which results in a product equal to 0. |
| product numbers | Multiplies all numbers. Blank and non-numeric values are ignored. |
| product ignore zero | Multiplies all non-zero numbers. ignoring p and non-numeric values. |
| count | Counts all non-blank values. Blank values are ignored. |
| count numbers | Counts all numbers. Blank and non-numeric values are ignored. |
| count ignore zero | Sums all non-zero numbers. 0 are ignored. |
| average | Calculates the average of all non-blank values. Blank values are ignored. All non-numeric values are treated as 0. |
| average numbers | Calculates the average of all numbers. Blank and non-numeric values are ignored |
| average ignore zero | Calculates the average of all non-zero numbers. 0 are ignored |
| rms | Calculates the root mean square of all non-blank values. Blank values are ignored. All non-numeric values are treated as 0. |
| rms numbers | Calculates the root mean square of all numbers. Blank and non-numeric values are ignored |
| rms ignore zero | Calculates the root mean square of all non-zero numbers. 0 are ignored |
| geometric mean | Calculates the geometric mean of all non-blank values. Blank values are ignored. All non-numeric values are treated as 0. |
| geometric mean numbers | Calculates the geometric mean of all numbers. Blank and non-numeric values are ignored |
| geometric mean ignore zero | Calculates the geometric mean of all non-zero numbers. 0 are ignored |
| harmonic mean ignore zero | Calculates the harmonic mean of all non-zero numbers. 0 are ignored. See 1 |
| parallel ignore zero | Calculates the parallel resistance fromula (Sum of inverse vaules, and inverted at the end) of all non-zero numbers. 0 are ignored. See 1 |
| variance | Calculates the variance of all non-blank values. Blank values are ignored. All non-numeric values are treated as 0. See 2 |
| variance numbers | Calculates the variance of all numbers. Blank and non-numeric values are ignored See 2 |
| variance ignore zero | Calculates the variance of all non-zero numbers. 0 are ignored See 2 |
| deviation | Calculates the standard deviation of all non-blank values. Blank values are ignored. All non-numeric values are treated as 0. See 2 |
| devation numbers | Calculates the standard deviation of all numbers. Blank and non-numeric values are ignored See 2 |
| deviation ignore zero | Calculates the standard deviation of all non-zero numbers. 0 are ignored See 2 |
| min abc | Finds the lowest alphabetic string value. Blank values are considered, and per se the smallest value overall. |
| min abc ignore blanks | Finds the lowest alphabetic string value, but blank values are ignored. |
| max abc | Finds the highest alphabetic string value. |
| append | Appends all string values using the data separator string provided (for example a comma) to separate the values. |
| append ignore blanks | Same as above, but blank values are ignored |
| append once | Appends all string values using the data separator string provided (for example a comma) to separate the values, but only 1 occurence per values. No repetitions. |
| append once ignore blanks | Same as above, but blank values are ignored |
1For the actions 'harmonic mean ignore zero' and 'parallel ignore zore', 0 as inputs are pr se not possible.
2Calculating variance and deviation requires at least two (2) data samples. Otherise a division-by-zero note will be retuned in the result.