See Also
This dialog is accessed from the local menu of a case information display by selecting Get Column Metrics from the Set/Toggle/Columns menu entry. The dialog allows you to determine the metrics for a set of columns. The metrics determined include: Sum, Average, Variance, Standard Deviation, Maximum, Minimum, Total Items, and Total Non-Zero Items.
By default the dialog is set to determine the metrics for the whole column of the case information display where the option has been selected. However, the selected record set can be modified.
Start Column, End Column
These values specify what columns to include in determining the metrics.
Start Row, End Row
These values specify what records to include when computing the metrics.
Treatment of blank cells
If the option Treat blank cells as zero is checked, any blank cells will be considered as zero when computing the metrics. Instead, if the option Ignore blank cells for calculation is checked, any blank cell will be taken out of the metrics calculation.
Use Absolute Values
Check this box to use the absolute values of field values for the metrics computation.
Update Metrics
Click this button to determine the metrics with the new set of options.