NthValue

 

Purpose:

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

Parameter:

All

Number         <n>, i.e. the index for the value which is to be produced, calculated e.g. with NthLargestIndex().

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:

NthValue(NthLargestIndex(Order_Details.ProductID,2))