Time List

Hi,

I'm using week calendar type & using 4-4-5 for week grouping into months/qtrs in the model. So whenever i used month as a time scale in a particular module and tried to use month() function, it's showing peculiar values, as shown in the attached screenshots. Can anybody tell a workaround to fix this.

upload2_39732.PNG

Accepted answers

jethrovanderveer

Hi Prashant,

I must admit this is odd. Haven't seen it before. I even get different outcomes when I apply your formula. Workaround for now: IF PREVIOUS('Month 2') = 12 THEN 1 ELSE PREVIOUS('Month 2') + 1. I included a printscreen to see the outcome of such a formula. This holds as long as the starting period of your fiscal year is January.

It might be an idea to send this to Anaplan Support to figure out why the formula doesn't hold in case of setting up the model with weeks as periods.

Best regards,

Jethro

month_count_39739.PNG

DavidSmith

@Prashant22may1

@jethrovanderveer

Hopefully this explains it.. The Start line item formula is START()

When using a weekly calendar (such as 4:4:5), the start of the "month" doesn't always correspond to the "Real" month start, as shown here. 29th of January is the "start" of February

The only real solution is to add a line to hold the "date" you really want. there are many methods in which you could automatically create the "real start" line item, but to be honest, it's a one time piece of work (and for subsequent years), and if you hold the values in a System module, it's not that onerous

I hope this helps

David

All comments

jethrovanderveer

Hi Prashant,

It might be an idea to send this to Anaplan Support to figure out why the formula doesn't hold in case of setting up the model with weeks as periods.

Best regards,

Jethro

month_count_39739.PNG

DavidSmith

@Prashant22may1

@jethrovanderveer

Hopefully this explains it.. The Start line item formula is START()

When using a weekly calendar (such as 4:4:5), the start of the "month" doesn't always correspond to the "Real" month start, as shown here. 29th of January is the "start" of February

I hope this helps

David

kavinkumar

HI Prashant,

I have a quite simple work arround for your scenario and this would be a Permanent fix eventhough if you change the time to next period.

Step 1: Create a Calendar List as per below screen shot. Make sure that you give correct code for all the items.

Time List.PNG

Step 2 : In the module put this formula and your solution is arrived. (I have set the time scale as you mentioned 4-4-5) Time List 1.PNG

So this will reduce future maintanance.

Hope this will solve your concerns.

Thanks,

Kavin.

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…