Creates and distinguishes lists that are processed by functions that
require list arguments. @LIST can be used to create expLists,
member lists, or rangeLists. @LIST treats
a collection of parameters as one entity.
@LIST (argument1, argument2, ..., argumentN)
argument1, argument2, …, argumentN
The list of arguments that are collected and treated as one argument
@LIST does not check for or eliminate duplicates.
The following example is based on the Sample Basic database. Assume
that the Year dimension contains an additional member, Sales Correl. @LIST
is used with the @CORRELATION function to determine the sales relationship
between a product’s two peak periods (Jan through Mar and Apr through May):
FIX(Sales) "Sales Correl" = @CORRELATION(SKIPNONE, @LIST(Jan,Feb,Mar),@LIST(Apr,May,Jun)); ENDFIX
This example produces the following report:
Colas Actual New York Sales ===== Jan 678 Feb 645 Mar 675 Apr 712 May 756 Jun 890 Sales Correl 0.200368468