SAP BO-FC 10.0

[diogogr]

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!

[Olga_Vasileva · Accepted solution]

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.

[diogogr · Accepted solution]

Excellent! Thanks!

[suresh_m · Accepted solution]

Great. Thanks.