Summarization Formula

The summarization formulas below are available for Crosstab and Chart scripting.

Type

Style Constant object

One of the (integer) constants below:

NONE_FORMULA

NTHMOSTFREQUENT_FORMULA

AVERAGE_FORMULA

NTHSMALLEST_FORMULA

CONCAT_FORMULA

POPULATIONSTANDARDDEVIATION_FORMULA

CORRELATION_FORMULA

POPULATIONVARIANCE_FORMULA

COUNT_FORMULA

PRODUCT_FORMULA

COVARIANCE_FORMULA

PTHPERCENTILE_FORMULA

DISTINCTCOUNT_FORMULA

STANDARDDEVIATION_FORMULA

MAX_FORMULA

SUMSQ_FORMULA

MEDIAN_FORMULA_FORMULA

SUMWT_FORMULA

MIN_FORMULA

SUM_FORMULA

MODE_FORMULA

VARIANCE_FORMULA

NTHLARGEST_FORMULA

WEIGHTEDAVERAGE_FORMULA

Example

formula = StyleConstant.AVERAGE_FORMULA;