Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
By a table like described you may use a call like:
$(=only({< Index = {n}>} formula))
By a table like described you may use a call like:
$(=only({< Index = {n}>} formula))
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.