3147132 - Week formula result is 1 week more - Report Story

Report Story Week formula result is 1 week more compared to the calendars search online

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

1. Create a Story type report
2. From the Story query or data source add a Week calculated column [Example: Week (TimeManagement#Employee_Time#StartDate)]
3. The result for the date December 3, 2021 is Week 49, while the calendar search online is Week 48

Expected behavior

Both the WEEK and ISOWEEK functions return the week number for a specified date, but the format of the result is quite different, and the two functions may handle the first week of the new year differently. For example, when supplied the date 2017-01-01, the WEEK function considers the date to be part of the first week of 2017 and returns 1, whereas ISOWEEK considers the date to be part of the last week of 2016 and returns 2016-W52.

Report Story follows the calculation of WEEK function while some calendars search online or embedded to user's desktop are following the logic of ISOWEEK

SAP HANA SQL Reference Guide for SAP HANA Platform - WEEK Function (Datetime) 

Week, Formula, Function, Report Story, Calculated column, SuccessFactors Reporting, Embedded , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem

SAP SuccessFactors HXM Core 2111 ; SAP SuccessFactors Platform all versions