This content has been marked as final. Show 3 replies
In my excel sheet if have columns with as name the year (2014,2013,2012, etc)
In the load script i have a calculated field where i use last (2014) and the previous year (2013).
Next year I need to use the columns 2015 and 2014.
I want to create a variable vLastYear and vPrevYear so I can use these in stead of hard coded data. So I only have to change the content of the 2 variables vLastYear and vPrevYear.
If( ( > ) ,Chr(9660), Chr(9650) ) As Direction
Any suggestions ??