hotw to obtain period of line item

Szarek

Hello,

I'm stuck on a formula that seems obvious to me. I would like to retrieve the time period of a line item :

Week : list formated.

time period by week : format time period, applies to week => i want to obtain time period for each week.

Any idea?

thx for your time !

Accepted answers

Szarek

I have finally solved this 😉

my data module for loan with pay day :

i have a calendar :

I have a calcul module :

My formula for "semaine3" is horrible but it works... If the pay day dont exist on the month (day 31 for february for exemple), it take the week of the last day wich exist of the month.

And finally my module to convert interest from month to week :

My mind was traped by the system module i have make before for the week list, I wanted at all costs to use it to convert the day of a month into a week....

thx for the help !

All comments

JJANIK

Hi Szarek, can you please add more details here, like what is the purpose of this mapping, is your model using weeks as time periods? How the blueprint looks like? Are you trying to get first week of the month for a reference? If yes, wouldn't it be better to have a time dime dimension that use weeks instead of months? OR have a separate System module where for each period by month you map Weeks, for example by getting period start date START() and using that date for finding week, but I think your model needs to be set with weeks in first place for that to work.

Szarek

week is not used as time period. it's a list, because we wanted to customize them per year.

alexpavel

@Szarek If I understood correctly you are in this situation: your initial data is input/calculated per Month (Time list) and you would like to have the same data in a week module where you have the mapping from your screen:

Jan 22: Week 1

Feb: Week 5

....etc...

If this is the case, then you should have the mapping in a system module, the other way around: a module with the Week List and the line-item as Time...

Week1: Jan 22

Week5: Feb 22

In order to take data from the Initial data per month, you can use a Lookup.

Hope it helps

Alex

Szarek

i will post the entire case, maybe this would be easier to explain , we want to make a cash budget by week.

but most of the information to make budget are in month, that's why we work in month time.

i have a system module to define the time period of each week (week are a list) :

I have a module with the loans, and the day of the payment (list formated)

I have a calculation module to "convert" day of month to the week

i have a module with the amount of interest and capital by month

and i want to obtain the result in the line item "test" wich have time YEAR and applies with week.

The problem is the week S13 is defined on march 2022 in first module, but have the first april in too.

so i made the formula :

Rbt_interest[SUM: week, LOOKUP: SYS Semaine.Mois]

so i wanted to replace the month of my first module by the month of the week.

i am not sure its very clear, hard to explaind and i am french 🙂

alexpavel

@Szarek Usually, the formula should be something like this: Rbt_interest[SUM: week, SUM: Year of Month]

However, Time list is a special list that does not behave the same way as "normal" list, especially it is needed to change the granularity of the data.

If I understood correctly your case: you need to start from Data granularity is at Month Level and you want to arrive to a granularity of Year, Week level, where Month and Year are part of Time Anaplan list.

As previously stated, this can be achieved by changing the necessity to have SUM into LOOKUP:

It is needed that every week/Year combination to have associated with the correct Month (see below picture in line-item "Rbt Month")

This is start Data granularity:

And this is Data granularity: Year, Week using LOOKUP

Hope it helps

Alex

Szarek

I have finally solved this 😉

my data module for loan with pay day :

i have a calendar :

I have a calcul module :

My formula for "semaine3" is horrible but it works... If the pay day dont exist on the month (day 31 for february for exemple), it take the week of the last day wich exist of the month.

And finally my module to convert interest from month to week :

My mind was traped by the system module i have make before for the week list, I wanted at all costs to use it to convert the day of a month into a week....

thx for the help !

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…