Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: 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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.