LibreOffice LibreOffice 7.4 SDK API Reference
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.

XFormattedField

## ◆ 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.