2 Replies Latest reply: Jun 16, 2017 3:56 PM by Vassiliki Moutsana RSS

    Evaluation of constructed variable

    Vassiliki Moutsana

      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?