Any straight way to know the start month number as per Current FY?

CommunityMember126793
Regular Contributor

Any straight way to know the start month number as per Current FY?

Hi Friends, is there any formula / straight way to know the month number of the Current Fiscal Year? e.g. if the CURRENT FISCAL YEAR in Time Setting is as below

CommunityMember126793_1-1634481802570.png

Then Apr'2021 is first month of FY22. How to calculate like below?

TIME SCALE --> Apr  May  Jun  Jul ...... Mar

LINE ITEM -->     1       2       3      4  ...... 12

 

Please suggest!

1 ACCEPTED SOLUTION

Accepted Solutions
chilled0ut
Occasional Contributor

Re: Any straight way to know the start month number as per Current FY?

Create a time module with line items and formula as per belowchilled0ut_0-1634498739932.png

 

It should result in the following: (I've hidden some months so you can see the results across years)

chilled0ut_1-1634498846786.png

 

View solution in original post

2 REPLIES 2
anand.shekhawat
Super Contributor

Re: Any straight way to know the start month number as per Current FY?

@CommunityMember126793 

Try this

Step 1) Create a Time Calculation module as below

anandshekhawat_0-1634483679381.png

write the formulas as written above.

 

Step 2) Create the data module with time as a dimension as shown below

anandshekhawat_1-1634483783333.png

Your result should look like below

anandshekhawat_2-1634483877525.png

 

~Anand

 

chilled0ut
Occasional Contributor

Re: Any straight way to know the start month number as per Current FY?

Create a time module with line items and formula as per belowchilled0ut_0-1634498739932.png

 

It should result in the following: (I've hidden some months so you can see the results across years)

chilled0ut_1-1634498846786.png

 

View solution in original post