How to obtain start month of a financial year?

Highlighted
Occasional Contributor

How to obtain start month of a financial year?

Hello Experts,

 

I'd like to obtain start month of a fiscal year.

What I have now is current fiscal year in number format. And what I want to do is to compare item(time) and start month of a fiscal year, and get boolean for this, if item(time) is larger than start month of a fiscal year.

 

thanks in advance.

Tsuyoshi_Inoue_0-1593505005285.png

 

Regards,

Inoue

 

5 REPLIES 5
Highlighted
Certified Master Anaplanner

Re: How to obtain start month of a financial year?

Hi @Tsuyoshi_Inoue 

If I understood your question correctly, you want a flag against months whether that month is first month of a fiscal year or not. If that's the case, try the solution below:

1. Create a line item "Fiscal Year" formatted as time period - Year

2. Use the formula "PERIOD(START())" in the line item

3. Then use "START() = START(Fiscal Year)" to identify whether it's the first month or not

Screenshot 2020-06-30 at 2.06.54 PM.png

Fiscal Year = PERIOD(START())

Fiscal Year Start = START() = START(Fiscal Year)

Not First Month of FY = START() <> START(Fiscal Year)
Thanks
Anik
Highlighted
Occasional Contributor

Re: How to obtain start month of a financial year?

Hello Anik,

 

Thanks for your kind reply.

 

In my purpose, there is already "2020" (number format) specified.

Then month after Apr 20 should have true in boolean, on the other hand, in this case, all month in 2018 and 2019 should become false in boolean.

Could you please suggest another solution for this?

 

Highlighted
Master Anaplanner/Community Boss

Re: How to obtain start month of a financial year?

@Tsuyoshi_Inoue 

 

You don't need to convert the time periods in order to compare. You can compare the time periods directly by saying ITEM(TIME) >PERIOD(CURRENTPERIODEND()) assuming you have current period set up on TIME 

Highlighted
Certified Master Anaplanner

Re: How to obtain start month of a financial year?

@Tsuyoshi_Inoue 

It is easier to do calc on a period/ date formatted line item when it comes to calc with time periods.

 

Can you tweak the formulas to this:

Fiscal Year: PERIOD(CURRENTPERIODSTART())

Not First Month of FY: START() > START(Fiscal Year)

Thanks
Anik
Highlighted
Occasional Contributor

Re: How to obtain start month of a financial year?

Hi Anik,

 

OMG CURRENTPERIODSTART is so useful! Thanks so much!

 

Regards,

Inoue