I want to check only April from the period

KubotaNatsuki
KubotaNatsuki
in Modeling

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.

Tagged:

Best Answers

  • AntonMineev
    AntonMineev
    Answer ✓

    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
    KubotaNatsuki
    Answer ✓

    Thank you for your reply!!

    I was able to do what I wanted to do!

    Thank you!

     

Comments

  • AntonMineev
    AntonMineev

    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!

Categories