What is it?
The Summation from Column filter provides a simple way to generate an output row that applies a sum, median, mean, mode, or range to a selected column. It offers a quick and easy method to extract key values from your data without manual calculations or the need to apply these types of formulas to your output.
How is it used?
Add Table Filter > More Filters ... > Summation from column
The Summation from Column filter can be applied to any or all columns in a parsing rule. Once the column has been specified, you can choose the option to apply a calculation for that column with the options sum, median, mean, mode and range. If applied to any non-numeric column or mixed column, the filter will output 0 or the result of the found numbers, respectively.
The Collapse to Summation option will collapse the result into only the summary row. If you are looking to output only the result and not the entire row, this filter pairs well with "Keep Columns [X] to [Y]" and "Convert to Running Text".