1*b1cdbd2cSJim Jagielski/************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_report_Calculation_idl__ 24*b1cdbd2cSJim Jagielski#define __com_sun_star_report_Calculation_idl__ 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski//============================================================================= 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski module com { module sun { module star { module report { 30*b1cdbd2cSJim Jagielski 31*b1cdbd2cSJim Jagielski//============================================================================= 32*b1cdbd2cSJim Jagielski 33*b1cdbd2cSJim Jagielski/** Specifies how to calculate a value. 34*b1cdbd2cSJim Jagielski @see XFormattedField 35*b1cdbd2cSJim Jagielski */ 36*b1cdbd2cSJim Jagielskipublished constants Calculation 37*b1cdbd2cSJim Jagielski{ 38*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 39*b1cdbd2cSJim Jagielski 40*b1cdbd2cSJim Jagielski /** returns the average of a field. 41*b1cdbd2cSJim Jagielski */ 42*b1cdbd2cSJim Jagielski const short NONE = 0; 43*b1cdbd2cSJim Jagielski 44*b1cdbd2cSJim Jagielski /** returns the average of a field. 45*b1cdbd2cSJim Jagielski */ 46*b1cdbd2cSJim Jagielski const short AVERAGE = 1; 47*b1cdbd2cSJim Jagielski 48*b1cdbd2cSJim Jagielski /** returns the correlation of two fields. 49*b1cdbd2cSJim Jagielski */ 50*b1cdbd2cSJim Jagielski const short CORRELATION = 2; 51*b1cdbd2cSJim Jagielski 52*b1cdbd2cSJim Jagielski /** counts the number of values, from the field. 53*b1cdbd2cSJim Jagielski */ 54*b1cdbd2cSJim Jagielski const short COUNT = 3; 55*b1cdbd2cSJim Jagielski 56*b1cdbd2cSJim Jagielski /** returns the measure of the linear relation between paired variables. 57*b1cdbd2cSJim Jagielski */ 58*b1cdbd2cSJim Jagielski const short COVARIANCE = 4; 59*b1cdbd2cSJim Jagielski 60*b1cdbd2cSJim Jagielski /** returns the number of none repeating values, from the field. 61*b1cdbd2cSJim Jagielski */ 62*b1cdbd2cSJim Jagielski const short DISTINCTCOUNT = 5; 63*b1cdbd2cSJim Jagielski 64*b1cdbd2cSJim Jagielski /** returns the largest value from the field. 65*b1cdbd2cSJim Jagielski */ 66*b1cdbd2cSJim Jagielski const short MAXIMUM = 6; 67*b1cdbd2cSJim Jagielski 68*b1cdbd2cSJim Jagielski /** returns the middle value in a sequence of numeric values. 69*b1cdbd2cSJim Jagielski */ 70*b1cdbd2cSJim Jagielski const short MEDIAN = 7; 71*b1cdbd2cSJim Jagielski 72*b1cdbd2cSJim Jagielski /** returns the smallest value from the field. 73*b1cdbd2cSJim Jagielski */ 74*b1cdbd2cSJim Jagielski const short MINIMUM = 8; 75*b1cdbd2cSJim Jagielski 76*b1cdbd2cSJim Jagielski /** returns the most frequently returning value from the field. 77*b1cdbd2cSJim Jagielski */ 78*b1cdbd2cSJim Jagielski const short MODE = 9; 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski /** returns the Nth largest value from the field. 81*b1cdbd2cSJim Jagielski */ 82*b1cdbd2cSJim Jagielski const short NTHLARGEST = 10; 83*b1cdbd2cSJim Jagielski 84*b1cdbd2cSJim Jagielski /** returns the Nth most commonly occurring value from the field. 85*b1cdbd2cSJim Jagielski */ 86*b1cdbd2cSJim Jagielski const short NTHMOSTFREQUENT = 11; 87*b1cdbd2cSJim Jagielski 88*b1cdbd2cSJim Jagielski /** returns the Nth smallest value from the field. 89*b1cdbd2cSJim Jagielski */ 90*b1cdbd2cSJim Jagielski const short NTHSMALLEST = 12; 91*b1cdbd2cSJim Jagielski 92*b1cdbd2cSJim Jagielski /** returns as a percentage of the grand total summary. 93*b1cdbd2cSJim Jagielski */ 94*b1cdbd2cSJim Jagielski const short PERCENTAGE = 13; 95*b1cdbd2cSJim Jagielski 96*b1cdbd2cSJim Jagielski /** returns the value for a specified percentile in a Number or Currency field. 97*b1cdbd2cSJim Jagielski */ 98*b1cdbd2cSJim Jagielski const short PERCENTILE = 14; 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski /** returns how much each value in the field deviate from the mean or average value for that field. 101*b1cdbd2cSJim Jagielski */ 102*b1cdbd2cSJim Jagielski const short POPSTANDARDDEVIATION = 15; 103*b1cdbd2cSJim Jagielski 104*b1cdbd2cSJim Jagielski /** returns the square of the standard deviation. 105*b1cdbd2cSJim Jagielski */ 106*b1cdbd2cSJim Jagielski const short POPVARIANCE = 16; 107*b1cdbd2cSJim Jagielski 108*b1cdbd2cSJim Jagielski /** returns the sample standard deviation for the field. 109*b1cdbd2cSJim Jagielski */ 110*b1cdbd2cSJim Jagielski const short SAMPLESTANDARDDEVIATION = 17; 111*b1cdbd2cSJim Jagielski 112*b1cdbd2cSJim Jagielski /** returns the sample variance for the field. 113*b1cdbd2cSJim Jagielski */ 114*b1cdbd2cSJim Jagielski const short SAMPLEVARIANCE = 18; 115*b1cdbd2cSJim Jagielski 116*b1cdbd2cSJim Jagielski /** returns the total of all the values for the field. 117*b1cdbd2cSJim Jagielski */ 118*b1cdbd2cSJim Jagielski const short SUM = 19; 119*b1cdbd2cSJim Jagielski 120*b1cdbd2cSJim Jagielski /** returns the weighted average for the field. 121*b1cdbd2cSJim Jagielski */ 122*b1cdbd2cSJim Jagielski const short WEIGHTEDAVG = 20; 123*b1cdbd2cSJim Jagielski}; 124*b1cdbd2cSJim Jagielski 125*b1cdbd2cSJim Jagielski//============================================================================= 126*b1cdbd2cSJim Jagielski 127*b1cdbd2cSJim Jagielski}; }; }; }; 128*b1cdbd2cSJim Jagielski 129*b1cdbd2cSJim Jagielski/*============================================================================= 130*b1cdbd2cSJim Jagielski 131*b1cdbd2cSJim Jagielski=============================================================================*/ 132*b1cdbd2cSJim Jagielski#endif 133