<html> <head> <title>Enum GeneralFunction</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="navimain"><a href="GeneralFunction-xref.html" class="navimain">Use</a></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="#Values" class="navisub">Values</a></td> <td class="navisub"><a href="#ValueDetails" class="navisub">Values' 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">sheet</a> :: </p> </td> </tr> <tr> <td class="title">enum GeneralFunction</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>used to specify a function to be calculated from values. </dd> </dl> </td> </tr> </table> <hr> <a name="Values"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Values</td> </tr> <tr> <td class="imsum_left"><a href="#NONE">NONE</a></td> <td class="imsum_right">nothing is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#AUTO">AUTO</a></td> <td class="imsum_right">function is determined automatically. </td> </tr> <tr> <td class="imsum_left"><a href="#SUM">SUM</a></td> <td class="imsum_right">sum of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#COUNT">COUNT</a></td> <td class="imsum_right">all values, including non-numerical values, are counted. </td> </tr> <tr> <td class="imsum_left"><a href="#AVERAGE">AVERAGE</a></td> <td class="imsum_right">average of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#MAX">MAX</a></td> <td class="imsum_right">maximum value of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#MIN">MIN</a></td> <td class="imsum_right">minimum value of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#PRODUCT">PRODUCT</a></td> <td class="imsum_right">product of all numerical values is calculated. </td> </tr> <tr> <td class="imsum_left"><a href="#COUNTNUMS">COUNTNUMS</a></td> <td class="imsum_right">numerical values are counted. </td> </tr> <tr> <td class="imsum_left"><a href="#STDEV">STDEV</a></td> <td class="imsum_right">standard deviation is calculated based on a sample. </td> </tr> <tr> <td class="imsum_left"><a href="#STDEVP">STDEVP</a></td> <td class="imsum_right">standard deviation is calculated based on the entire population. </td> </tr> <tr> <td class="imsum_left"><a href="#VAR">VAR</a></td> <td class="imsum_right">variance is calculated based on a sample. </td> </tr> <tr> <td class="imsum_left"><a href="#VARP">VARP</a></td> <td class="imsum_right">variance is calculated based on the entire population. </td> </tr> </table> <a name="ValueDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Values' 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><b>NONE</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>nothing is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="AUTO" class="membertitle">AUTO</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>AUTO</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>function is determined automatically. </dd> <dd><p>If the values are all numerical, SUM is used, otherwise COUNT.</p> </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><b>SUM</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>sum of all numerical values is calculated. </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><b>COUNT</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>all values, including non-numerical values, are counted. </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><b>AVERAGE</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>average of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MAX" class="membertitle">MAX</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>MAX</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>maximum value of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MIN" class="membertitle">MIN</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>MIN</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>minimum value of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="PRODUCT" class="membertitle">PRODUCT</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>PRODUCT</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>product of all numerical values is calculated. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="COUNTNUMS" class="membertitle">COUNTNUMS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>COUNTNUMS</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>numerical values are counted. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="STDEV" class="membertitle">STDEV</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>STDEV</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>standard deviation is calculated based on a sample. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="STDEVP" class="membertitle">STDEVP</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>STDEVP</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>standard deviation is calculated based on the entire population. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="VAR" class="membertitle">VAR</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>VAR</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>variance is calculated based on a sample. </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="VARP" class="membertitle">VARP</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td><b>VARP</b>,<hr> <dl> <dt><b>Description</b></dt> <dd>variance is calculated based on the entire population. </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>