Set variable to field value in load script

[#1]

Hi all.

Is there anyone that could explain how I could set av varibale in my load script (SET Current_FC = BudgetType=('FC2 2013');) and then use the variable in a set analysis like:

sum({$<PeriodCounter={"$(#=max(PeriodCounter-1))"}, $(Current_FC) ,Cost_Center_ID-={'10600'}>} BudgetAmount) *-1/1000

Thanks in advance!

[karolina_ · Accepted solution]

have you tried just SET Current_FC = 'FC2 2013';

because with {'FC2 2013'} you have double brackets BudgetType={{'FC2 2013'}}

or try
SET Current_FC = FC2 2013;

and then BudgetType={'$(Current_FC)'}>

[#3]

Thanks for your reply en the solution thats works for me is:

In the script - SET Current_FC = 'FC2 2013';

In the expression - BudgetType={[$(Current_BC)]}