Formula getting "Current" Fiscal Year as NUMBER

Options
J_wheeler
J_wheeler Member, ALL USERS, Partner Posts: 5 Occasional Contributor
in Planning & Modeling

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

Tagged:

Comments

  • Ansar.Sayfin
    Ansar.Sayfin Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    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

Categories