LibreOffice
LibreOffice 6.0 SDK API Reference
Variables
com::sun::star::report::Calculation Constant Group Reference

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

const short AVERAGE = 1

returns the average of a field.

const short CORRELATION = 2

returns the correlation of two fields.

const short COUNT = 3

counts the number of values, from the field.

const short COVARIANCE = 4

returns the measure of the linear relation between paired variables.

const short DISTINCTCOUNT = 5

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

const short MAXIMUM = 6

returns the largest value from the field.

const short MEDIAN = 7

returns the middle value in a sequence of numeric values.

const short MINIMUM = 8

returns the smallest value from the field.

const short MODE = 9

returns the most frequently returning value from the field.

const short NONE = 0

returns the average of a field.

const short NTHLARGEST = 10

returns the Nth largest value from the field.

const short NTHMOSTFREQUENT = 11

returns the Nth most commonly occurring value from the field.

const short NTHSMALLEST = 12

returns the Nth smallest value from the field.

const short PERCENTAGE = 13

returns as a percentage of the grand total summary.

const short PERCENTILE = 14

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

const short POPSTANDARDDEVIATION = 15

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

const short POPVARIANCE = 16

returns the square of the standard deviation.

const short SAMPLESTANDARDDEVIATION = 17

returns the sample standard deviation for the field.

const short SAMPLEVARIANCE = 18

returns the sample variance for the field.

const short SUM = 19

returns the total of all the values for the field.

const short WEIGHTEDAVG = 20

returns the weighted average for the field.