Evaluation of constructed variable

[#1]

Hi everyone,

I am having an issue with the variable evaluation in a formula using a simple sum. I have two columns named A_text1 and A_text2 and a KPI that will be the sum(A_text1) or sum(A_text2) depending on a user choice of text1 or text2 through an extension variable. More specifically the user selects text1/text2 which is then stored in a variable called Selection so I construct the A_text1 through the expression: 'A_'&'$(Selection)' which gives me what i want. However, the formula is not working when using the sum('A_'&'$(Selection)').

Can anyone help me please?

[sunny_talwar · Accepted solution]

Try this:

Sum($(='PLN_'&'$(Selection)'))

[#3]

I cannot thank you enough!!