SmartLists

You can include a Smart List as a variable in a formula expression, such as the formula expression, “Product Channel”=[[Channel.Retail]].

“Product Channel” is the account with type "Smart List", Channel is the Smart List name, and Retail is a Smart List entry. If the Smart List ID for Retail is 2, Channel.Retail is replaced with a 2 in the member formula (the application treats Smart Lists as numbers). If the Smart List ID for Retail is 2, 2 is put in the calculation, and 2 is stored in the database.

Calculation Manager Syntax:

[[SLName.entryname]]

Example:

The following syntax:

FIX (Mar, Actual, Working, FY15, P_000, "111") 
   "Product Channel" =[[Channel.Retail]] ;
ENDFIX

returns the following script:

FIX (Mar, Actual, Working, FY15, P_000, "111") 
   "Product Channel" =2 ;
ENDFIX