Contents - Index


SUMPARAMETRIC

 

SUMPARAMETRIC returns the sum of all or selected cells in a specified column of the Parametric table.  The format of this function is:

 

SUMPARAMETRIC('TableName', 'ColumnName')

 

or

 

SUMPARAMETRIC('TableName', 'ColumnName', RowStart, RowStop)

 

'TableName' is a string constant or string variable that contains the name of the Parametric table.  The name of the Parametric table is shown on its tab at the top of the table.

 

''ColumnName' is a integer value, string constant or string variable the identifies the column.  If an integer value is provided, it is taken to be the column number in the Parametric table.  If a string constant is provided, it is assumed to be the name of the variable for the column in the Parametric table.  If a string variable is provided, it must contain the name of one of the variables in the Parametric table.

 

RowStart and RowStop are integers or EES variables specifying the starting and stopping rows for which the sum will be performed.  These parameters are optional.  However, if values are not provided for RowStart and RowStop, EES will assume that the function should be applied to the entire Parametric table, which can require significant computational effort.  There are two ways to eliminate this problem.  

 

1.  Specify the start row and use TableRun# as the stop row.  (See example)

2.  Place the equation within a $DoLast  ...   $EndDoLast clause.

 

Note that the sum of all rows in the Parametric table can be viewed by selecting the "Include a Sum Row in the Parametric Table" control in the General tab of the Preferences dialog Alternatively, the sum row can be made visible with the $SUMROW ON directive.

 

Note that the SumParametric function cannot work if one or more rows in the specified column does not contain a number.  A warning is issued when this situation occurs.  If you wish to use the SumParametric function to keep a running total of the sum, enter the range of rows and use the TableRun#  to indicate the current row, e.g., 

 

SumParametric('Table 1','X', 1, TableRun#)

 

 

See also:   AVGPARAMETRIC

                 AVGLOOKUP

 STDDEVLOOKUP

                 SUMLOOKUP

                 SUMPARAMETRIC

                 TABLEVALUE

  Mathematical Functions