Specifies how to calculate a value. More...

Variables
const short	NONE = 0
	returns the average of a field. More...

const short	AVERAGE = 1
	returns the average of a field. More...

const short	CORRELATION = 2
	returns the correlation of two fields. More...

const short	COUNT = 3
	counts the number of values, from the field. More...

const short	COVARIANCE = 4
	returns the measure of the linear relation between paired variables. More...

const short	DISTINCTCOUNT = 5
	returns the number of none repeating values, from the field. More...

const short	MAXIMUM = 6
	returns the largest value from the field. More...

const short	MEDIAN = 7
	returns the middle value in a sequence of numeric values. More...

const short	MINIMUM = 8
	returns the smallest value from the field. More...

const short	MODE = 9
	returns the most frequently returning value from the field. More...

const short	NTHLARGEST = 10
	returns the Nth largest value from the field. More...

const short	NTHMOSTFREQUENT = 11
	returns the Nth most commonly occurring value from the field. More...

const short	NTHSMALLEST = 12
	returns the Nth smallest value from the field. More...

const short	PERCENTAGE = 13
	returns as a percentage of the grand total summary. More...

const short	PERCENTILE = 14
	returns the value for a specified percentile in a Number or Currency field. More...

const short	POPSTANDARDDEVIATION = 15
	returns how much each value in the field deviate from the mean or average value for that field. More...

const short	POPVARIANCE = 16
	returns the square of the standard deviation. More...

const short	SAMPLESTANDARDDEVIATION = 17
	returns the sample standard deviation for the field. More...

const short	SAMPLEVARIANCE = 18
	returns the sample variance for the field. More...

const short	SUM = 19
	returns the total of all the values for the field. More...

const short	WEIGHTEDAVG = 20
	returns the weighted average for the field. More...

Detailed Description

Specifies how to calculate a value.

See also: XFormattedField

Variable Documentation

◆ AVERAGE

const short AVERAGE = 1

returns the average of a field.

◆ CORRELATION

const short CORRELATION = 2

returns the correlation of two fields.

◆ COUNT

const short COUNT = 3

counts the number of values, from the field.

◆ COVARIANCE

const short COVARIANCE = 4

returns the measure of the linear relation between paired variables.

◆ DISTINCTCOUNT

const short DISTINCTCOUNT = 5

returns the number of none repeating values, from the field.

◆ MAXIMUM

const short MAXIMUM = 6

returns the largest value from the field.

◆ MEDIAN

const short MEDIAN = 7

returns the middle value in a sequence of numeric values.

◆ MINIMUM

const short MINIMUM = 8

returns the smallest value from the field.

◆ MODE

const short MODE = 9

returns the most frequently returning value from the field.

◆ NONE

const short NONE = 0

returns the average of a field.

◆ NTHLARGEST

const short NTHLARGEST = 10

returns the Nth largest value from the field.

◆ NTHMOSTFREQUENT

const short NTHMOSTFREQUENT = 11

returns the Nth most commonly occurring value from the field.

◆ NTHSMALLEST

const short NTHSMALLEST = 12

returns the Nth smallest value from the field.

◆ PERCENTAGE

const short PERCENTAGE = 13

returns as a percentage of the grand total summary.

◆ PERCENTILE

const short PERCENTILE = 14

returns the value for a specified percentile in a Number or Currency field.

◆ POPSTANDARDDEVIATION

const short POPSTANDARDDEVIATION = 15

returns how much each value in the field deviate from the mean or average value for that field.

◆ POPVARIANCE

const short POPVARIANCE = 16

returns the square of the standard deviation.

◆ SAMPLESTANDARDDEVIATION

const short SAMPLESTANDARDDEVIATION = 17

returns the sample standard deviation for the field.

◆ SAMPLEVARIANCE

const short SAMPLEVARIANCE = 18

returns the sample variance for the field.

◆ SUM

const short SUM = 19

returns the total of all the values for the field.

◆ WEIGHTEDAVG

const short WEIGHTEDAVG = 20

returns the weighted average for the field.

Variables