Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Data Browsing/Editing > Browse/Edit a Table or View

Calculations

Scroll Prev Top Next More

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.