Indirect value in a chart expression

[ZoharB]

Hi,

In a KPI I want to show a measure which is in a field.
For instance: instead of defining "count(cities)" as the measure I have a field in a table called "formula" and it contains different texts:
"count(cities)"
"Max(cities)"
"Avg(cities)" and more.
Also there is a way to select the formula I want (by another field in that table, such as INDEX).
My question - how do I write the  expression in the chart so that the text in the seledted  formula will be executed, in another words - indirect use of an expression?

Thanks

Zohar

[marcus_sommer · Accepted solution]

By a table like described you may use a call like:

$(=only({< Index = {n}>} formula))

[ZoharB]

Hi, thank you for your reply.

In fact I solved it even in an easier way.

I defined the variable vFormulaText = (Formula) and used vFormulaText in the KPI. Works perfectly.