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

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…