How to get the first year from a Boolean

KubotaNatsuki

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!

Accepted answers

All comments

Akhtar.shahbaz

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

KubotaNatsuki

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?

Akhtar.shahbaz

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

KubotaNatsuki

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!

Edwar151

@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

Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
Dynamic Export Reporting
Hi All, I want to address an query related to exports, In Output model, which is read access for all users & roles.user want to have dynamic export depending on user selection of multiple regions. So for selected regions , they will be able to see the data only for selected regions. Thanks,
1.5.2 activity: import data into beginning inventory
Kindly assist me to load data into the model.