Store formulas/expressions in variables

[curiousfellow]

To make expressions not to complicated, I stored some expressions in variables. The stored expressions contain variables too.

Should it be possible to use variables like this. For every dimension I get the same result now.

For example : stored in var1 = sum({<year={"=$(var_chosen_year)"}>}sales)

                                                var2 = sum({<year={"=$(var_compare_year)"}>}sales)

In my chart :

dimension : department

expression: $(var1)-$var(2)

[curiousfellow · Accepted solution]

SOLVED : I created the content of the variable starting with the "=" sign". Without that character it works 

[MayilVahanan]

Hi

For Dynamic, remove the "=" equal sign from the formula and try like $(var1)

var1:

sum({<year={"=$(var_chosen_year)"}>}sales)