> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# PercentileCont

The **PercentileCont** function calculates the continuous k<sup>th</sup> percentile value for a column or group. It returns the percent of the total frequency under that number, demonstrating the relative position of the value compared to the entire set of data.

The **PercentileCont** function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see [Group columns in a table](/docs/create-and-manage-tables#group-columns-in-a-table).

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see [Add summary statistics to a table](/docs/create-and-manage-tables#add-summary-statistics-to-a-table).

To learn more about using aggregate functions, see [Building complex formulas with grouped data](https://www.sigmacomputing.com/resources/training-videos/table-grouping-and-functions#complex-formulas).

## Syntax

`PercentileCont(column, k)`

The function has the following arguments:

<dl>
  <dt>
    column
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    The column to search.
  </dd>

  <dt>
    k
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    A number between 

    <code>0</code>

     and 

    <code>1</code>

    , which corresponds to the percent of data below that number.
  </dd>

  <dd>
    <code>0 < k < 1</code>
  </dd>
</dl>

## Example

```
PercentileCont([Score], 0.7)
```

If the column `[Score]` contains values 2, 4, 6, 8, and 10, returns `7.6` when used in a table summary.

## Related resources

* [PercentileDisc](/docs/percentiledisc)
* [Avg](/docs/avg)
* [Median](/docs/median)