# GridCountPercentile (PQL)

Returns the number of items that are above or below the percentile for the entire grid/query.

- Returned Output: Numeric
- Library: PQL \ Dynamic \ Grid
- Version: 2020.02.000
- Compatibility: Any content (regardless of data source) in the relevant parts of the application

#### Syntax

* Click on the function's arguments above for more details on the input values.

##### Comments

- The numeric value is a decimal amount representing the percentile from 0 to 1.
- The boolean is a true/false (1/0) to count those above (true) or below (false) the average.
- The entire grid's data set is considered in the function.

#### Examples

The example below uses the following example grid.

This example returns 37 - being the number of data points that exceed the 25th percentile for the entire grid.

GridCountPercentile(0.25, "true")