'[KPI ' & $(vParameter1)& ' ' & 'Parameter]'
in a KPI box does indeed create the correct fieldname = [KPI AltAvg Parameter]
HOWEVER, if I wrap that statement in sum() it breaks.
I have tried creating a Let vParamString = '[KPI ' & $(vParameter1)& ' ' & 'Parameter]' in the loadscript and also in the variable editor (independently).
Unfortunately, the resulting variables don't populate the values and the result of it is the string entered, not the intended variable-created name.
I've also learned that in creating a select box with the Fieldname in it - when I create the associated variable, I simply enter the fieldname in the description. If I attempt to use GetFieldSelections(Fieldname) it fails (with or without preceding =). Leaving just the fieldname does populate the variable accordingly when it is selected, however I'm still unable to get it to work properly
I've scoured the net and apparently no one else wants to do this
Ok, using that concept, I was able to construct the string, as well as create a variable that returns the correct result!! Almost there.
Now I have:
$vParam = '[KPI' & Parameter & ' ' & 'Parameter]'
so in a KPI box, I can show $(vParam) and it will display
[KPI AltMax Parameter]
So I got greedy and wrapped a sum() around it. it said 'no'.
I tried: sum($(=vParam)) as well.
Since the result of this variable I wanted to be taken to be literal, I'm assuming I'm missing some syntax here?