Subset

Return to: Calculated Member Builder Function List

Returns a subset of elements from a set.

Syntax

Subset(«Set», «Start»[, «Count»])

Remarks

Returns «Count» elements from «Set», starting at position «Start». «Start» is zero-based: 0 corresponds to the first element in the set, 1 corresponds to the second, and so on. If «Count» is not specified, all elements from «Start» to the end of the set are returned.

Example

Subset({USA, Canada, France, Germany, Japan, England, Peru}, 0, 2)

returns the set

{USA, Canada}.

 

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