Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator III
Creator III

Add calendar weeks with number - turn of the year

Hi,
the report always shows data from the current week and then from the next week and the one after that, up to 12 weeks in the future.

reporting_neu_0-1665478108129.png

(KW = calendar week)

In the report, the employee can select the year and the calendar week in selection box.

So I use for the next Week: 

 

GetFieldSelections([MASTER_CAL.Week])+1

 

For the week after:

 

GetFieldSelections([MASTER_CAL.Week])+2

 

then +3, +4, ...+12

But now the year ends in calendar week 52 and it shows week 53 instead of 1.

How can I adjust the formula so he knows a new year is about to begin?

In the calculations I use:

 

Sum({1<[WPL.Week] = {"$(=[MASTER_CAL.Week]+12)"}, [WPL.Year] = {"$(=Year(Today()))"}>}[WPL.Capacity])

Can you help me please? 🙂 

 

Labels (1)
1 Reply
reporting_neu
Creator III
Creator III
Author

Unfortunately I have to ask again:

Does anyone know how I can add calendar weeks when a new year is coming up? 😔

Like:
Current Calendar Week is 49.

[CalendarWeek]+1 = 50
[CalendarWeek]+2 = 51
[CalendarWeek]+3 = 52
[CalendarWeek]+4 = 1 (new Year)

I can't handle the turn of the year.