Count

 

Purpose:

Counts the number of values of the first argument. With this function, all Null values in the argument are included in the count. Use the CountIf() function when you want to disregard Null values.

Hint: Sum variables (see Sum Variables) are an alternative way of creating counters. Sum variables are principally applicable to whole tables. Aggregate functions principally table specific.

Parameter:

All                   Values to count (sets the value to count). Needed to define the table (subtable) for which the records shall be counted.

Boolean         (optional) TRUE: The values which were stored for the calculation are deleted after output. (default: TRUE). Please note that the stored calculation values are generally deleted for every (sub)table end. The second parameter only decides whether the values will be already deleted within the table.

Return value:

Number

Example:

Count(Order_Details.ProductID)

NthLargest(Article.Price,Count(Distinct(Artikel.Stkpreis),True)-1, True)

Calculates the second-smallest value, only taking repeated values into account once.