How to Get Correct Month in a Weekly Time scale Model

I have a 4-4-5 Weekly Model. Details below

Time Scale

I wanted to get the exact month for a particular date. Details below

Formula?

Period(Valid from) for 5/31/2020 is giving the month as Jun 20 and not May 20. I understand that it will fall in a week which will be in Jun but how to get the correct month from this date?

Thank you.

Accepted answers

anikdas

Hi @AnkitGupta

Please use the following formula. It should give the desired output:

PERIOD(DATE(YEAR(Valid from), MONTH(Valid from), 15))

Let me know if it works

All comments

anikdas

Hi @AnkitGupta

Please use the following formula. It should give the desired output:

PERIOD(DATE(YEAR(Valid from), MONTH(Valid from), 15))

Let me know if it works

AnkitGupta

Thank you @anikdas that was quick!

It works, thanks a lot for the help!🙏

Misbah

@AnkitGupta

If it is only for Reporting purposes then @anikdas' solution will work seamlessly. But if you are trying to aggregate the numbers based on those weeks then you may have to take additional pain of converting Anaplan's calendar to Gregorian calendar. Beautiful article written by me friend @JaredDolich Link Below

Convert Values from a 445 Calendar to a Normal, Mo... - Anaplan Community

JaredDolich

@AnkitGupta

Definitely have a look at the article @Misbah mentioned. It's a bit more than you need to identify the month but you can use the system modules. You'll want to be sure to include the logic for a leap year and decide how you will address the endpoints of your calendar. The last month of a 445 may end before the fiscal year (Gregorian) ends, for example December 27th. What will you do if someone enters December 28?

Thanks for the shout out @Misbah - you're amazing.

Quick Links

Can you help?

Unanswered questions

ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…