I have created a variable, which is a sum expression for some generic value set satisfying some condition.(Created using script)[ var1 = sum({$(=if( -- ))}) ]
Now i want to create another variable from this existing variable, for which I want to check one more condtion,
I have created a sample app with my requirement, attaching the same here.
Here, I have a filter Year / Scenario. I have kept three KPI's for CurrentMIS, CurrentBUD and PreviousMIS.
In my selection of a specific year(selection for Year alone), i want these KPI to reflect accordingly.
I don't want to change the definition of the variable $(Var_Expense) and $(Var_Revenue) in the app. (Actually in my scenario, the value for these variable is coming from a database script). I want to add some filter in each KPI expression to check whether its Scenario code is CurresntMIS, CurrentBUD, or PreviousMIS ??
