Purpose:

Calculates the index of 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:

NthLargestIndex(Order_Details.ProductID,2)