Question Re: SAP BO-FC 10.0 in Financial Management Q&A

SAP BO-FC 10.0

diogogr — Wed, 30 Oct 2019 11:53:14 GMT

Hello,

I'm having a problem when using the following formula:

FUNCPER(YEAR(-1; REF_PER))[yyyy.mm]

I want to show the previous year of the reference period I´m running the schedule for. The formula above works if I use a value bigger then 0 (nex year) but I get an error message if the value is lower then 0.

According to the formula wizard, function YEAR 'Displays last period of nth year following (n>0) or prior (n<0) period p (f = DFIRST).

Any ideas?

Thanks!

Re: SAP BO-FC 10.0

Olga_Vasileva — Wed, 30 Oct 2019 12:13:42 GMT

Hello Diogo,

The only way I know to get the previous year from reference year in formula is by the following workaround:

LEFT(FUNCPER(REF_PER)[yyyy];2)&RIGHT(FUNCPER(YEAR(99;REF_PER))[yyyy];2)

Hope it helps.

Re: SAP BO-FC 10.0

diogogr — Wed, 30 Oct 2019 12:25:46 GMT

Excellent! Thanks!

Re: SAP BO-FC 10.0

suresh_m — Mon, 14 Sep 2020 09:58:22 GMT

Great. Thanks.