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

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
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.…