I want to check only April from the period

KubotaNatsuki
Frequent Contributor

I want to check only April from the period

hi! 

 

I want to check only April from the period.

The reason is to use the cumulate function.
I'd like to check only April in Boolean, is there any good way?

As a concrete content, I want to check only in April of FY19-FY22 (month period)

I am not good at English and may not be able to communicate well, but thank you.

2 ACCEPTED SOLUTIONS

Accepted Solutions
AntonMineev
Certified Master Anaplanner

Re: I want to check only April from the period

Hi @KubotaNatsuki!

I didn't fully understand the question. But if you want to define April in each year as "Boolean", then you can use the formula "Month(ITEM(TIME))". It returns the month number from ITEM(TIME). If the return is 4 (it is better to indicate this in a separate LI, and not as a hardcode), then by comparing the indicators you will receive TRUE for all April.

View solution in original post

KubotaNatsuki
Frequent Contributor

Re: I want to check only April from the period

Thank you for your reply!!

I was able to do what I wanted to do!

Thank you!

 

View solution in original post

3 REPLIES 3
AntonMineev
Certified Master Anaplanner

Re: I want to check only April from the period

Hi @KubotaNatsuki!

I didn't fully understand the question. But if you want to define April in each year as "Boolean", then you can use the formula "Month(ITEM(TIME))". It returns the month number from ITEM(TIME). If the return is 4 (it is better to indicate this in a separate LI, and not as a hardcode), then by comparing the indicators you will receive TRUE for all April.

KubotaNatsuki
Frequent Contributor

Re: I want to check only April from the period

Thank you for your reply!!

I was able to do what I wanted to do!

Thank you!

 

AntonMineev
Certified Master Anaplanner

Re: I want to check only April from the period

Glad I could help. If previous answer is appropriate, you can mark it as "Solution".

This affects the stats on my profile and helps others look for answers to the same question (or look for unanswered questions to provide assistance). Thank you!