Skip to Content
0
Jul 22, 2020 at 06:53 PM

How to fix number of weeks issue if it falls on the last week of december

46 Views

Hi everyone,

Please see the pic below

sapquestionweek.jpg

I wanted to sort the data based on the year and the week of the year that I noticed if the date is 12/31 or 12/30, webi shows it as the first week. How this issue can be resolved? for the week, I am using this formula:

=Week([Created Date Time]) as dimension/

Thanks,

Attachments