use a variable to create another variable

[#1]

Hi,

I am not an expert so I am probably not doing this extremely efficiently but here goes.

I want to be able to present the user with listbox so they can define the current month called CurrentMonth e.g. Jun-14 and then for another variable to populate with a number relating to that month.

I created a list with month names, this populates the list box they see:

load * inline
[CurrentMonth
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
Jan-15

I also created a table with the month numbers

load * inline
[Period, PeriodNum,PeriodName
11501,25,Jul-14
11502,26,Aug-14
11503,27,Sep-14
11504,28,Oct-14

CurrentMonth and PeriodName are the same data and when the user selects the CurrentMonth of Jul-14 I want a variable called vCurrentPeriodNum to return 25

I dont want them to filter the report to only show Jul-14 so I am doing this to be able to define a formula going back a number of months from what is defined as the current month

Does this make sense?

Thanks

David

[MK_QSL]

Question is not clear ! Could you please describe little more for your requirement?

[#3]

I'll rewrite it it posted halfway through sorry

[ramoncova06]

I am not complete sure I got what you trying to explain, but I believe you want to use dual function, How to use- Dual()