Special variable concatenation.

[#1]

Hi, everyone. Hope you are doing good. My problem is the following:

I have a variable called 'v_SelectedMonth' (if the selected month is 'Jan', the variable adopts 'January'; if the selected value is 'Feb', the variable adopts 'February'. You get the point).

Now, separately, I have twelve variables: v_DolarCotizationJanuary, v_DolarCotizationFebruary... etc.

And I need to do a division: the divisor is one of those twelve values, depending on the selected month: so, if I select 'Nov', I want 'v_DolarCotizationNovember' to be my divisor, and I want to achieve that value through the concatenation of 'v_DolarCotization' and the content of v_SelectedMonth. I need to do something like this

Amount / if(Moneda='Peso',1,$('v_DolarCotization' & $(v_SelectedMonth)) ) * (-1)

Of course, I am here because that doesn't work.

Does anyone know how can I achieve this?

Thank you very much!

[Gysbert_Wassenaar]

Perhaps this: $(='v_DolarCotization' & $(v_SelectedMonth))

[#3]

Good one, Gysbert. But sadly, it did not work for me : (

[jerem1234 · Accepted solution]

Maybe:

$(='v_DolarCotization' & v_SelectedMonth)

[#5]

Yeah! You nailed it, jerem1234! Thank you very much!