Calculations can be performed on the table data using built-in aggregate functions, tally, group, and crosstab. The number of duplicate values with a column can also be determined. From the "Calculate option on the Data Browser menu bar, the following options are available:
•Compute... - computes statistical data such as Count, Rows, Minimum, Maximum, Sum, Average, Standard Deviation and Variance for a column's values
•Tally... - tallies the number of occurrences for each unique column value
•Group... - groups each unique column value and displays each
•Crosstab... - creates a crosstab output of the columns from the table that you configure
•Aggregate... - displays the Count, Rows, Minimum, Maximum, Sum, Average, Standard Deviation or Variance of the column values in the column header
•Duplicates... - calculates the number of duplicate occurrences for the column
Function |
Description |
Average |
Computes the numeric average of CURRENCY, DOUBLE, NUMERIC, REAL, INTEGER, DATE, or TIME data types. R:BASE rounds averages of integer values to the nearest integer value and currency values to their nearest unit. |
Count |
Determines how many non-null entries there are for a particular column item. |
Maximum |
Selects the maximum value in a column. This option accepts columns with any data type except BIT, VARBIT, VARCHAR, and BITNOTE. * |
Minimum |
Selects the minimum value in a column. This option accepts columns with any data type except BIT, VARBIT, VARCHAR, and BITNOTE. * |
Standard Deviation |
Computes standard deviation for CURRENCY, DOUBLE, REAL, NUMERIC, or INTEGER data types. The standard deviation is a measure of how widely values are dispersed from the average value. |
Sum |
Computes the numeric sum of CURRENCY, DOUBLE, REAL, NUMERIC, or INTEGER data types. |
Variance |
Determines variance for CURRENCY, DECIMAL, DOUBLE, REAL, NUMERIC, or INTEGER data types. |
* Selecting aggregate functions, such as MIN and MAX, requires that R:BASE keeps an accumulator and choose to only use the first 80 characters for NOTE values. This matches the fact that if you sort on NOTE fields, the sort will be based on the first 80 characters only.
