Tail

Return to: Calculated Member Builder Function List

Returns a subset from the end of a set.

Syntax

Tail(«Set»[, «Count»])

Remarks

Returns the last «Count» elements in a set. The order of elements is preserved. The default value of «Count» is 1. If «Count» is less than 1, the empty set is returned. If «Count» exceeds the number of tuples in the set, the original set is returned.

Example

Tail({USA, Canada, France, Germany, Japan}, 3)

returns the set

{France, Germany, Japan}.

 

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.