Constants' Group Calculation

Overview

Module

Use

Devguide

Index

Constants

Constants' Details

:: com :: sun :: star :: report ::

constants group Calculation

Description: Specifies how to calculate a value.
See also: XFormattedField

Constants
NONE	returns the average of a field.
AVERAGE	returns the average of a field.
CORRELATION	returns the correlation of two fields.
COUNT	counts the number of values, from the field.
COVARIANCE	returns the measure of the linear relation between paired variables.
DISTINCTCOUNT	returns the number of none repeating values, from the field.
MAXIMUM	returns the largest value from the field.
MEDIAN	returns the middle value in a sequence of numeric values.
MINIMUM	returns the smallest value from the field.
MODE	returns the most frequently returning value from the field.
NTHLARGEST	returns the Nth largest value from the field.
NTHMOSTFREQUENT	returns the Nth most commonly occurring value from the field.
NTHSMALLEST	returns the Nth smallest value from the field.
PERCENTAGE	returns as a percentage of the grand total summary.
PERCENTILE	returns the value for a specified percentile in a Number or Currency field.
POPSTANDARDDEVIATION	returns how much each value in the field deviate from the mean or average value for that field.
POPVARIANCE	returns the square of the standard deviation.
SAMPLESTANDARDDEVIATION	returns the sample standard deviation for the field.
SAMPLEVARIANCE	returns the sample variance for the field.
SUM	returns the total of all the values for the field.
WEIGHTEDAVG	returns the weighted average for the field.

Constants' Details

NONE

const short NONE = 0; Description returns the average of a field.

AVERAGE

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

CORRELATION

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

COUNT

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

COVARIANCE

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

DISTINCTCOUNT

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

MAXIMUM

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

MEDIAN

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

MINIMUM

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

MODE

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

NTHLARGEST

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

NTHMOSTFREQUENT

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

NTHSMALLEST

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

PERCENTAGE

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

PERCENTILE

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

POPSTANDARDDEVIATION

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

POPVARIANCE

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

SAMPLESTANDARDDEVIATION

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

SAMPLEVARIANCE

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

SUM

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

WEIGHTEDAVG

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

Top of Page

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

API

SDK

Tips ‘n’ Tricks

Miscellaneous