Formula getting "Current" Fiscal Year as NUMBER

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

Best Answer

  • 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