I want to get the first month of a period set in module calender.

Thank for your reply!
Sorry...I want to display it in a module with no time axis and no Apply To.
So your method is a bit different.
Do you know how to do it？

KirillKuznetsov

@KubotaNatsuki

Not sure i understood correctly. What means no Apply to?

But you can try to create a list with a single element in it which will repersent the first month of the time scale.You will add it as a dimention of your module.

And then using mapping to time period make a lookup to collect values from sources which have time scale.

Otherwise, please share your idea with some more details.

Ingilavicus

Hi @KubotaNatsuki,

You can also do a timesum() will be able to retrieve the first nonblank item of a timescale. Only limit is that you can't do a timesum() directly across periods you have to convert a period to data and then back to period again:

First Period Line item has no Applies to, just a single line item.

Andris

ManjunathKN

Hi @KubotaNatsuki

Formula given above is correct.
I have break it down for you and highlighted the formula in yellow.
Module with time dimension

Module without time dimension

Thanks
Manjunath

Kavadera

Nice trick, but it wouldn't allow to calculate last month as well. Is there a simple way to calculate both first and last time periods without need to create auxiliary items with timescale applied? 🙂

ManjunathKN

Hi @Kavadera

Please find the below way to find the last month.

I am not sure if this is what you were asking.

Thanks,
Manjunath

Kavadera

Hi, @ManjunathKN

What you've provided is last month for a year. What I try to get is the last period in the whole timescale. But when I try to get END() from TIME.All periods I get blank for some reason 😞

The previos solution with TIMESUM worked great for first month, but I can't apply it to find the last one as well

ManjunathKN

Hi,

I tried something for you, not sure it is best solution.

you need to create a boolean check for checking the last period, you can also automate this with formula MAX(CUMULATE(1, FALSE), 1) > 59 (is total period in timescale -1) its still a hardcode, if i find anything i will let you know.

Hope this is helpful,

Thanks,
Manjunath

ManjunathKN

Hi @Kavadera

Thanks,
Manjunath

Kavadera

Haha, @ManjunathKN

Thanks for trying but I think CUMULATE is an overkill here 😄

Guess, there's just no way you can possibly get that result without creating an auxiliary line item with time dimension. Yet another argument against using system timescale in Anaplan

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
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…
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.…