How to include variables inside variables in script?
Hello everyone,
I am trying to pass all my expression to the script, so that it will be easier to maintain and Debug.
However i am struggling with including an expression within another expression in the script.
Outside the script when i create the variables through the "Variable Overview" window, they work, however i cannot make them work when they are created in the script.
I have tried many combinations but none result in what i expected.
In the script i wrote the following:
LET vPeriodSelectionSales = '=Max({1<FLAG_Sales = {1}, Month = P(Month), Year = P(Year)>} Period)';
LET vYearSelectionSales = '=Max({1<FLAG_Sales = {1}, Month = P(Month), Year = P(Year)>} Year)';
LET vPeriodYearBeginning = '=Min({1<FLAG_Sales = {1}, Month = P(Month), Year = {$(vYearSelectionSales)} >} Period)';
I tried using "", using SET instead of LET, and many other combinations, but I cannot make vPeriodYearBeginning work because it is calling another variable. How can i make this variable work?
