Register

I want to check only April from the period

KubotaNatsuki
Occasional 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.

3 REPLIES 3
AntonMineev
Regular Contributor

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
Occasional 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
Regular Contributor

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!