CountAvg (PQL)

Returns the number of items that are above or below the average for the specified list.

  • 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

CountAvg( <Numeric List> , <Boolean> )

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

Comments
  • The numeric list is a list or array of values.
  • The boolean is a true/false (1/0) to count those above (true) or below (false) the average.

Examples

The example below uses the following example grid.

This example returns 3 using the first column (sales) above.

CountAvg(dataSetColumn(0), "true")