Evaluate dynamic variables in table

[dinnoroni]

Hi I have an island table as the following

id	var	exp
1	vMetric1	Sum(A)
2	vMetric2	Sum(B)
3	vMetric3	Sum(A)*Sum(B)
4	vMetric4	Sum(A)/Sum(B)

 in my scripts, I loop through the table build out variables dynamically.

In the dashboard I creating a table using id as the dimension and Maxtstring(var) is my expression. How can I evaluate the variables and get the value?

[marcus_sommer]

It's not possible because within the UI is no classical evaluate() available. The only exception is a $-sign expansion but it creates an ad-hoc variable which has always a single global value which is evaluated at first and then applied to all rows  / columns - means you couldn't apply it within a dimensional context.

- Marcus