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.

Regards,

Inoue

Accepted answers

anikdas

@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)

All comments

anikdas

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

Fiscal Year = PERIOD(START())

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

Not First Month of FY = START() <> START(Fiscal Year)

Tsuyoshi_Inoue

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?

Misbah

@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

anikdas

@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)

Tsuyoshi_Inoue

Hi Anik,

**** CURRENTPERIODSTART is so useful! Thanks so much!

Regards,

Inoue

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…