Skip to Content

Changing the Fiscal Year Definition

Mar 13 at 08:56 AM


avatar image

Hi there,

I have a date field BUSINESS_DATE in IDT. After exporting to webi, I used year(BUSINESS_DATE) which gives me results like 2017, 2018, 2019 etc. Apparently, dates like 21/01/18 are in the 2018 category.

I have a requirement that the fiscal year starts from April of an year till March end of next year and hence dates like 21/01/18 should come in 2017-18 category.

Can anyone help me on this, I have to implement the same requirement with a lot of dates.

Thanks in Advance..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mar 13 at 09:33 AM

try this.

=If(MonthNumberOfYear([Calendar Date]) InList (1;2;3)) Then Year([Calendar Date]) Else Year([Calendar Date])+1

Show 1 Share
10 |10000 characters needed characters left characters exceeded

There is a slight change in the formula

=If(MonthNumberOfYear([Calendar Date]) InList (1;2;3)) Then Year([Calendar Date])-1 Else Year([Calendar Date])

Leaving this, working fine. Thanks for the solution.