Week Calculation-Alternate way to put number of weeks in a year

Hi Everyone

I am using '52' to show previous year data of same month by subtracting: 'PY Month(week)' - 52

Is there a function or alternate way to use replace '52' and not use it in formula as a number but a derived value from some function or calculation?

Thanks!

Accepted answers

All comments

rob_marshall

@Aniruddha

How about this, create a SYS Week Properties module with 3 line items:

Week
Month
Last Month

Rob

ChrisAHeathcote

@Aniruddha

Assuming that the target module is dimensioned by time periods you can use the OFFSET function. This allows you to offset the reference by a stated number of time periods. If your using weeks then you will use 52, months you would use 12 and so on.

Therefore, in the you example use; OFFSET(DATA,-52) the negative value indicates that the function is going backs to retrieve the required value.

The offset value can be referenced to an input module where as a user you can flex the value but if its always going to be 52 weeks prior then hard coding it here is ok!

Note that this function only works if the data and target have the same time dimension.

jackcplanning

Hi @Aniruddha ,

Can you clarify your question? Are you looking to dynamically calculate # of weeks in a given year? 52 for normal years + 53 for other fiscal years?

Trying to understand your use case and possibly propose some solutions based on that.

Quick Links

Can you help?

Unanswered questions

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…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
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…