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