<html> <head> <title>Constants' Group Calculation</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimainnone">Use</td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">report</a> :: </p> </td> </tr> <tr> <td class="title"><table class="title-table" width="99%"> <tr> <td width="25%" class="title2">unpublished </td> <td width="50%" class="title">constants group Calculation</td> <td width="*"/></tr> </table> </td> </tr> <tr> <td><dl> <dt><b>Usage Restrictions</b></dt> <dd><i>not published</i></dd> <dt><b>Description</b></dt> <dd>Specifies how to calculate a value. </dd> <dt><b>See also</b></dt> <dd><a href="XFormattedField.html">XFormattedField</a></dd> </dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#NONE">NONE</a></td> <td class="imsum_right">returns the average of a field. </td> </tr> <tr> <td class="imsum_left"><a href="#AVERAGE">AVERAGE</a></td> <td class="imsum_right">returns the average of a field. </td> </tr> <tr> <td class="imsum_left"><a href="#CORRELATION">CORRELATION</a></td> <td class="imsum_right">returns the correlation of two fields. </td> </tr> <tr> <td class="imsum_left"><a href="#COUNT">COUNT</a></td> <td class="imsum_right">counts the number of values, from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#COVARIANCE">COVARIANCE</a></td> <td class="imsum_right">returns the measure of the linear relation between paired variables. </td> </tr> <tr> <td class="imsum_left"><a href="#DISTINCTCOUNT">DISTINCTCOUNT</a></td> <td class="imsum_right">returns the number of none repeating values, from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#MAXIMUM">MAXIMUM</a></td> <td class="imsum_right">returns the largest value from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#MEDIAN">MEDIAN</a></td> <td class="imsum_right">returns the middle value in a sequence of numeric values. </td> </tr> <tr> <td class="imsum_left"><a href="#MINIMUM">MINIMUM</a></td> <td class="imsum_right">returns the smallest value from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#MODE">MODE</a></td> <td class="imsum_right">returns the most frequently returning value from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#NTHLARGEST">NTHLARGEST</a></td> <td class="imsum_right">returns the Nth largest value from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#NTHMOSTFREQUENT">NTHMOSTFREQUENT</a></td> <td class="imsum_right">returns the Nth most commonly occurring value from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#NTHSMALLEST">NTHSMALLEST</a></td> <td class="imsum_right">returns the Nth smallest value from the field. </td> </tr> <tr> <td class="imsum_left"><a href="#PERCENTAGE">PERCENTAGE</a></td> <td class="imsum_right">returns as a percentage of the grand total summary. </td> </tr> <tr> <td class="imsum_left"><a href="#PERCENTILE">PERCENTILE</a></td> <td class="imsum_right">returns the value for a specified percentile in a Number or Currency field. </td> </tr> <tr> <td class="imsum_left"><a href="#POPSTANDARDDEVIATION">POPSTANDARDDEVIATION</a></td> <td class="imsum_right">returns how much each value in the field deviate from the mean or average value for that field. </td> </tr> <tr> <td class="imsum_left"><a href="#POPVARIANCE">POPVARIANCE</a></td> <td class="imsum_right">returns the square of the standard deviation. </td> </tr> <tr> <td class="imsum_left"><a href="#SAMPLESTANDARDDEVIATION">SAMPLESTANDARDDEVIATION</a></td> <td class="imsum_right">returns the sample standard deviation for the field. </td> </tr> <tr> <td class="imsum_left"><a href="#SAMPLEVARIANCE">SAMPLEVARIANCE</a></td> <td class="imsum_right">returns the sample variance for the field. </td> </tr> <tr> <td class="imsum_left"><a href="#SUM">SUM</a></td> <td class="imsum_right">returns the total of all the values for the field. </td> </tr> <tr> <td class="imsum_left"><a href="#WEIGHTEDAVG">WEIGHTEDAVG</a></td> <td class="imsum_right">returns the weighted average for the field. </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="NONE" class="membertitle">NONE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>NONE</b> = 0;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the average of a field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="AVERAGE" class="membertitle">AVERAGE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>AVERAGE</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the average of a field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="CORRELATION" class="membertitle">CORRELATION</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>CORRELATION</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the correlation of two fields. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="COUNT" class="membertitle">COUNT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>COUNT</b> = 3;<hr> <dl> <dt><b>Description</b></dt> <dd>counts the number of values, from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="COVARIANCE" class="membertitle">COVARIANCE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>COVARIANCE</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the measure of the linear relation between paired variables. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DISTINCTCOUNT" class="membertitle">DISTINCTCOUNT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>DISTINCTCOUNT</b> = 5;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the number of none repeating values, from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MAXIMUM" class="membertitle">MAXIMUM</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MAXIMUM</b> = 6;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the largest value from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MEDIAN" class="membertitle">MEDIAN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MEDIAN</b> = 7;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the middle value in a sequence of numeric values. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MINIMUM" class="membertitle">MINIMUM</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MINIMUM</b> = 8;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the smallest value from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MODE" class="membertitle">MODE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>MODE</b> = 9;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the most frequently returning value from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NTHLARGEST" class="membertitle">NTHLARGEST</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>NTHLARGEST</b> = 10;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the Nth largest value from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NTHMOSTFREQUENT" class="membertitle">NTHMOSTFREQUENT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>NTHMOSTFREQUENT</b> = 11;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the Nth most commonly occurring value from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="NTHSMALLEST" class="membertitle">NTHSMALLEST</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>NTHSMALLEST</b> = 12;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the Nth smallest value from the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="PERCENTAGE" class="membertitle">PERCENTAGE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>PERCENTAGE</b> = 13;<hr> <dl> <dt><b>Description</b></dt> <dd>returns as a percentage of the grand total summary. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="PERCENTILE" class="membertitle">PERCENTILE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>PERCENTILE</b> = 14;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the value for a specified percentile in a Number or Currency field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="POPSTANDARDDEVIATION" class="membertitle">POPSTANDARDDEVIATION</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>POPSTANDARDDEVIATION</b> = 15;<hr> <dl> <dt><b>Description</b></dt> <dd>returns how much each value in the field deviate from the mean or average value for that field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="POPVARIANCE" class="membertitle">POPVARIANCE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>POPVARIANCE</b> = 16;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the square of the standard deviation. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SAMPLESTANDARDDEVIATION" class="membertitle">SAMPLESTANDARDDEVIATION</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>SAMPLESTANDARDDEVIATION</b> = 17;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the sample standard deviation for the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SAMPLEVARIANCE" class="membertitle">SAMPLEVARIANCE</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>SAMPLEVARIANCE</b> = 18;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the sample variance for the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="SUM" class="membertitle">SUM</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>SUM</b> = 19;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the total of all the values for the field. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="WEIGHTEDAVG" class="membertitle">WEIGHTEDAVG</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const short <b>WEIGHTEDAVG</b> = 20;<hr> <dl> <dt><b>Description</b></dt> <dd>returns the weighted average for the field. </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
