Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i have a table that sums production by weeks.
the weeks appears as expression.
something like that:
product | week35 | week36 | week37 |
---|---|---|---|
1 | 100 | 200 | |
2 | 200 | ||
3 | 100 | ||
the season starts at week 35 (September).
i wish to show only past weeks when the future weeks are hidden.
my condition is Week(Today())>='week no.'
problem: on the first weeks of the year, i need to present weeks with larger week number then today's week
glad for any assistance
thanks
avner
Hi,
Tanks for the help, but since i have also future dates on my model i couldn't use it.
anyway my solution is to create two different conditions, depending on the week's number (over or under 35).
for weeks above 35 : if((Week(Today())<'35'),1,Week(Today())>='Week no.')
for weeks under 35: if((Week(Today())<'35'),Week(Today())>='Week no.',0)
Cheers
Avner
Hi Avner
Try to create a new concatenated dimension of Year and Week (i.e. 201301-201352).
Than try to change the condition to:
Year(today())&Week(today()) >= 'YearWeek'
Yaniv
Concatenate year before your week number
Hi,
Tanks for the help, but since i have also future dates on my model i couldn't use it.
anyway my solution is to create two different conditions, depending on the week's number (over or under 35).
for weeks above 35 : if((Week(Today())<'35'),1,Week(Today())>='Week no.')
for weeks under 35: if((Week(Today())<'35'),Week(Today())>='Week no.',0)
Cheers
Avner