Skip to Content

BPC10.1 - EPM 10 SP 28 Rolling forecast – monthly incorrect formulas return

I have a fiscal period April – March

Need to have a rolling forecast – monthly

If current month = 2016.AUG than APR-JUL will be ACTUAL and the remainder (AUG to MAR) will be FORECAST

(FORECAST = S4F.2016)

Step 1 – Works out fine however when I get to step2 and change the current period

Formula

“ACTUAL” 2016.APR

=IF(B9<$B$6,"ACTUAL",$B$7)

“ACTUAL” 2016.MAY

=IF(C9>$B$6,"ACTUAL",$B$7)

However when I get to step2 and change the current period to SEP or DEC

It move all the formulas around and change the sign from > to <

See below

Step 2

2016.MAY

=IF(C9>$B$6,"ACTUAL",$B$7)

This should have been ACTUAL not sure why it’s not picking up the ACTUAL Category

uzivg.jpeg (10.5 kB)
7fwll.jpeg (9.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 13, 2017 at 12:07 PM

    First of all your formula has to be referenced or included in the EPMOlapMeberO function, read here:

    https://blogs.sap.com/2013/03/01/static-report-in-bpc-nw-10/

    Second - in general it's better to copy ACTUAL months to forecast CATEGORY :)

    Add comment
    10|10000 characters needed characters exceeded