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

New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…