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

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…