nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get the first year from a Boolean

hi!

I want to get a year.

If there is a Boolean value at the beginning throughout the year, we get the year

How do i do?
Please help me!

Tags

Modeling

Calculation Functions

Accepted answers

All comments

Hi @KubotaNatsuki ,

you can try the below approach:

Module 1:

Module 2:

Check below scenario based on year selection

Scenario 1

Scenario 2

Hope this helps

Thanks

Akhtar

Thank you for reply!
My model doesn't have All Period...
Do not include All Periods as a condition.
Sorry...
Can I still do it?

Hi @Edwar151 & @KubotaNatsuki ,

Another way to get the same result by using TIMESUM formula for example:

I have created this module to define To & From Period

Hope this helps

Thanks

Akhtar

Thank you for reply!!
I know about it!
I would like to ask you one point: is it necessary to make a Date?
You've been so helpful!

@Akhtar.shahbaz wrote:
Hi @Edwar151 & @KubotaNatsuki ,

Another way to get the same result by using TIMESUM formula for example:
I have created this module to define To & From Period

Hope this helps
Thanks
Akhtar

Okay Thanks For Help!!!

Official website

Quick Links

Can you help?

Unanswered questions

Post man API services to trigger Export is failing when i try to export the file , any idea
I am getting the API error when i try to trigger export jobs through Anaplan API
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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…