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
Solved! Go to Solution.