How to convert Date to 445 calendar week
The requirement from the client is that they will upload the sales history for an SKU by date into Anaplan. Hence there will be 3 columns SKU, Date, Quantity. The model calendar is set as 445 calendar and the end of fiscal year is last Sunday. The problem is I want to convert this flat upload so that I can aggregate the data in a module which has a dimension of SKU and Model timescale with line item as Qty.
I am stuck at a point where I am unable to convert date to 445 week format. Please suggest a way to handle this problem.