variable in table and evaluate

[amien]

I havd a table which contains two fields:kpi_name and variable_name

for example

kpi_name   , variable_name

1               , vFormula1.Expr

2               , vFormula2.Expr

is it possible to create a pivot with kpi_name as dimension and variable_name as expression. BUT the expression should also be evaluated

=$(=variable_name)

This will give me the right expression for each kpi_name, but it's not evaluated

Thanks in advanced

[Gysbert_Wassenaar · Accepted solution]

If you have a field named variable_name that contains the names of variables that contain expressions you can use the variable_name field in expressions like this $($(=variable_name)) to evaluate the expression in the variable with the same name as the selected value of variable_name.

[amien]

Tnx