How to convert Weeks to Month?

Hi All,

I have a list with custom month format and the list code is 'mmm-yy Code' example: 'Apr-21 VLIB0065E' (below image)

However, the source file i have received is in Year-Week example '2021-01' (2021 = Year, 01- first week of 2021 which is Jan)

How do i convert weeks to month?

Accepted answers

All comments

rob_marshall

@Kayley

Not really the answer to your question, but I would strongly suggest you change the architecture of your list where you don't have "Time" as part of the member. Instead, use a module dimensionalized by time for the time data which in turn allows you only use the "non time" member once. For more information about this, please check out this best practice article.

https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

Rob

Ingilavicus

Hi @Kayley ,

Don't think you would get a concrete answer on this one. How would you like to convert weeks to Months? Month value should represent calendar month or month value that you would see in a typical weekly calendar?

If you can't change the source data one idea would be to enable a weekly calendar in your model to load the data in, but not sure how this would impact the rest of the model.

Also to give a bit of an insight into this type of conversion I would suggest you take a look at this answer given by @JaredDolich :

https://community.anaplan.com/t5/Anaplan-Platform/How-to-Group-Total-sold-from-4-4-5-to-calendar-month-if-data-is/m-p/59616#M10638

Might help you evaluate how you want to convert these weekly values to monthly.

Andris

Quick Links

Can you help?

Unanswered questions

Compare/Sync new module that is working properly from Dev to PROD model _no amounts in PROD
I have created a Module "report" in DEV and it is working properly there, then I used Compare/Synce to bring into PROD, but for some reason it is not working properly in PROD. I have not amounts in PROD. I did check for any missing constants. Can anyone help with this issue or any advise?
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…