<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>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 © 2008 Sun Microsystems, Inc.</p> </div> <!-- id="adc-idlref" --> </body> </html>