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

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Create a time module with line items and formula as per below

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

2 REPLIES 2
Valued Contributor

Try this

Step 1) Create a Time Calculation module as below

write the formulas as written above.

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

Your result should look like below

~Anand

Contributor

Create a time module with line items and formula as per below

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