pthPercentile(p, column[, group[,condition]])

Calculates the pth percentile, by group, of values in a specified column. The pth percentile is the value below which p percent of the records in the group fall. The pthPercentile() function is only available to elements within a Section.

Parameters

p desired percentile value

column column label of the column to summarize

group column label of the group to summarize

condition condition on the group to summarize

Return

p-th percentile of all values in a group

Example

text = pthPercentile(p,"Quantity", "State",
   "field['Discount']>0");

See Also

pthPercentile(tablelens,p,column[, group,condition]), for the Table version.

SI.22, Section Object, for additional functions pertaining to Sections.

Sections, for scripting issues related to Sections.

<< populationVariance(column[, group[,condition]]) © 1996-2013 InetSoft Technology Corporation (v11.4) product(column[, group[,condition]]) >>