Formula getting "Current" Fiscal Year as NUMBER

[J_wheeler]

Hi, Anplan friends,

May I have pointers how to get current fiscal year as NUMBER ?

For example, In case where "Fiscal Year Start Month" is April and "Current Period" is March 2019, I would like to have "2018" in a line item. Do you know of any such a formula ? Initially I thought "YEAR(CURRENTPERIODSTART())" would work, but this gave "2019" as CURRENTPERIODSTART() would give "2019/03/01" when "Current Period" is March 2019.

Thanks in advance,

Regards,

John

[Ansar.Sayfin · Accepted solution]

Hello,

You should use more complex formula ie if fiscal year is over on Jun: =year(curperstart()) - if month(start())>6 then 0 else 1

Thanks