Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm having a table with the values
FilmWeek Year, FilmWeek WeekNbr, FilmWeek YWeek, FilmWeek PrevWeek Year, FilmWeek PrevWeek Week
I'm having listboxes in filmweek year, filmweek weeknbr, and would need the Yweek and the prevweek year & weeknbr into variables, so that i can use these variables in a set-analysis.
But can't find a way to set them without a macro.
Kind regards, Harry
If I understand your problem correctly, you shouldn't need to get the values in variables for use in a Set Expression. You should be able to refer to them directly like
$(=Only(Yweek))
Do not know, whether it is the best way, but I would create an inputbox for a variable, enter required formulae under Settings and then hide this box somewhere. Hence you have a variable, having always an updated value (which you may also see physically and/or overwrite during the testing)
HTH
Peter
If I understand your problem correctly, you shouldn't need to get the values in variables for use in a Set Expression. You should be able to refer to them directly like
$(=Only(Yweek))