correlation(tablelens,column1,column2 [,condition])

Calculates the correlation between two columns.

Parameters

tableLens the tableLens object of the table

column1 column label of the primary column

column2 column label of the column to correlate

condition condition on the group to summarize

Return

correlation between the two columns

Example

text = correlation(Table1.tableLens,'Quantity','Total',
   "Discount>0");

See Also

correlation(column, column2[, group[,condition]]), for the Section version.

SI.6, Table Object , for additional functions pertaining to Tables.

Data Tables, for scripting issues related to fixed Tables.

<< concat(tablelens,column[,condition]) © 1996-2013 InetSoft Technology Corporation (v11.4) count(tablelens,column[,condition]) >>