# InetSoft Reporting Software: Report Functions

This is a continuation of the section that presents functions for Table and Section operations in InetSoft's dashboard reporting software.

 #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index

## nthLargest(n, column[, group[,condition]])

Calculates the nth largest value in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```n the nth largest value to search
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`nth largest value in a group`

Example

```text = nthLargest(2, "Quantity","State",
"field['Discount']>0");```
 View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.

## nthMostFrequent(n, column[, group[,condition]])

Calculates the nth most frequently occurring value in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```n nth most frequent occurring value to search
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`nth most frequent occurring value in a group`

Example

```text = nthMostFrequent(2,"Quantity","State",
"field['Discount']>0");```
 View live interactive examples in InetSoft's dashboard and visualization gallery.

## nthSmallest(n, column[, group[,condition]])

Calculates the nth smallest value in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```n the nth smallest value to search
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`nth smallest value in a group`

Example

```text = nthSmallest(2,"Quantity","State",
"field['Discount']>0");```
 Read what InetSoft customers and partners have said about their selection of Style Scope for their solution for dashboard reporting.

## populationStandardDeviation(column[, group,condition])

Calculates the population standard deviation of values in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`population standard deviation of all values in a group.`

Example

```text = populationStandardDeviation("Quantity", "State",
"field['Discount']>0");```
 Read what InetSoft customers and partners have said about their selection of Style Report as their production reporting tool.

## populationVariance(column[, group[,condition]])

Calculates the population variance of values in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`population variance of all values in a group`

Example

```text = populationVariance("Quantity","State",
"field['Discount']>0");```
 Read the top 10 reasons for selecting InetSoft as your BI partner.

## 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");`
 Learn how InetSoft's data intelligence technology is central to delivering efficient business intelligence.

## product(column[, group[,condition]])

Calculates the product of values in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`product of all values in a group`

Example

`text = product("Quantity", "State", "field['Discount']>0");`
 Learn how InetSoft's native big data application is specifically designed for a big data operating system.

## standardDeviation(column[, group[,condition]])

Calculates the (sample) standard deviation of values in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`standard deviation of all values in a group`

Example

`text = standardDeviation("Quantity","State", "field['Discount']>0");`
 Read the Style Intelligence datasheet for a detailed explanation of the platform's capabilities and features.

## sum(column[, group[,condition]])

Calculates the sum of values in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`sum of all values in a group`

Example

`text = sum("Quantity","State", "field['Discount']>0");`
 View live interactive examples in InetSoft's dashboard and visualization gallery.

## variance(column[, group[,condition]])

Calculates the (sample) variance of values in the specified column inside a group. This function is only available to elements within a Section.

Parameters

```column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`variance of all values in a group`

Example

`text = variance("Quantity","State", "field['Discount']>0");`
 #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index

## weightedAverage(column, column2[, group[,condition]])

Calculates the weighted average of values in the specified columns inside a group. This function is only available to elements within a Section.

Parameters

```column column label of the column to summarize
column2 column label of the second column to summarize
group column label of the group to summarize
condition condition on the group to summarize```

Return

`weighted average  of all values in a group`

Example

`text = weightedAverage("Quantity","State", "field['Discount']>0");`
 Previous: Reports Function Reference Next: Dashboard Objects