NthLargest

 

Purpose:

Calculates the nth-largest value of the set of values that result from the first parameter / formula.

Parameter:

Number

Number         <n>, i.e. the index for the value which is to be returned (1-based).

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 are already deleted within the table.

Return value:

Number

Example:

NthLargest(Order_Details.ProductID,2)       calculates the 2-largest number