Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I wonder if you could help me. I have a master calendar that has all the usual fields and i have also generated a week sequence number (WeekSEQ) which is an autonumber of week and year. I have a rolling 53 week report and the column headers seemed to have went off, think its because wk 53 only had 2 days and week one had 5. We need week 1 to start on 1st Jan and i am using broken weeks.
Currently the column labels i am using are: ='Wk:' & week(max(Date)) for current week, ='Wk:' & week(max(Date)-7) for last week etc.
When i use the max(WeekSEQ) and max(WeekSEQ)-1 this gives me the correct number (108 and 107) but this is of no use, is there a way i can replace WeekSEQ with week so it will show me Wk2, Wk1, Wk53, Wk52 etc.
Thanks
Is there a way in the column label i can replace WeekSEQ with Week. I have been looking but not getting anywhere with it.
There are a few posts on this one, surprised you did not find them, you need to change a system setting:
Broken Weeks setting is what I think you need to tweak here.
Cheers,
Brett
Hi Brett
I do use broken weeks. The issue is trying to get the week number from my week seq number so that the column labels are correct. When i use for the column header max(WeekSeq)-1 this gives me the correct week sequence number, but this is of no use. I need to use (WeekSeq) for the calculation but somehow replace this with the week number that the weekseq number relates to.
Paul