xref: /aoo41x/main/offapi/com/sun/star/report/Calculation.idl (revision d1766043)

/**************************************************************
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
 *************************************************************/


#ifndef __com_sun_star_report_Calculation_idl__
#define __com_sun_star_report_Calculation_idl__


//=============================================================================

 module com {  module sun {  module star {  module report {

//=============================================================================

/** Specifies how to calculate a value.
    @see XFormattedField
 */
published constants Calculation
{
    //-------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /** returns the weighted average for the field.
    */
    const short WEIGHTEDAVG = 20;
};

//=============================================================================

}; }; }; };

/*=============================================================================

=============================================================================*/
#endif