Minimum Version Required: 22.01
Steps
How to use the Table Calculator
1. Using universal search, navigate to any table view.
2. Click the Calculator icon located in the top right of the screen.
3. The Calculator opens in a mini-menu pop-up.
Note: the calculator pop-up can be dragged and moved anywhere on the screen.
4. Operations in the table calculator include:
Sum: Sum of the values selected
Avg: Sum of the values selected divided by the count of the values
Max: Highest value selected
Min: Lowest value selected
Count: Number of selected values
Unique Count: Number of unique selected values
%Diff: 100 - ((min / max) * 100
% Change: ((max - min) / min) * 100
5. Click any "column header" to select all values displayed in the column.
Click the "column header" again to deselect the values.
6. Click the Clear button to reset the calculations.
Users can manually create calculations by clicking the Manual option.
"Copy Values" allows the selected columns or boxes to be copied to the clipboard.