How to get the first year from a Boolean

KubotaNatsuki
Frequent Contributor

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!

KubotaNatsuki_1-1640068267430.png

 

 

5 REPLIES 5
Akhtar.shahbaz
Community Boss

Re: How to get the first year from a Boolean

Hi @KubotaNatsuki ,

 

you can try the below approach:

 

Module 1:

Screenshot_289.pngScreenshot_290.png

Module 2: 

Screenshot_291.pngScreenshot_292.png

Check below scenario based on year selection

Scenario 1

Screenshot_293.png

 

Scenario 2

Screenshot_294.png

 

Hope this helps

Thanks

Akhtar

 

KubotaNatsuki
Frequent Contributor

Re: How to get the first year from a Boolean

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
Community Boss

Re: How to get the first year from a Boolean

Hi @Edwar151 & @KubotaNatsuki ,

 

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

Screenshot_295.pngScreenshot_298.png

I have created this module to define To & From Period

Screenshot_299.png

 

Screenshot_300.pngScreenshot_301.png

 

Hope this helps

Thanks

Akhtar

KubotaNatsuki
Frequent Contributor

Re: How to get the first year from a Boolean

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
New Contributor

Re: How to get the first year from a Boolean


@Akhtar.shahbaz wrote:

Hi @Edwar151 & @KubotaNatsuki ,

 

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

Screenshot_295.pngScreenshot_298.png

I have created this module to define To & From Period

Screenshot_299.png

 

Screenshot_300.pngScreenshot_301.png

 

Hope this helps

Thanks

Akhtar

 

 

 

 

Okay Thanks For Help!!!

 

Official website