cancel
Showing results for 
Search instead for 
Did you mean: 

OFFLINE CALCULATION in EXCEL template--> IBP

0 Kudos
451

Hi,

We have to add offline calculation for keyfigure in IBP Template(Excel), can some one share some guide how can we do that.

Regards,

NC

Accepted Solutions (1)

Accepted Solutions (1)

lingaiahvanam
Active Contributor

Hi NC,

Please refer to the below link.

Link: https://blogs.sap.com/2016/12/16/how-to-add-local-member-in-ibp-planning-template/

Best Regards,

Lingaiah

Answers (2)

Answers (2)

Hello,

If you are using EPM Add-In can you please confirm if you have checked the "Use Excel Cell References" in the Local Member area inside the Report settings?

Hopefully, this might solve that.

Best Regards,

Tiago Carvalho.

former_member235875
Active Participant

Hi

you can create a new KF in the excel, you have to open the template in which you want the new KF then you have to go to Model management the in advanced then treat report EPM then you have to go to Local Members.

there you can make a KF only in the excel.

i hope this can help you

Jorge

0 Kudos

HI Jorge,

I got to know how we can add the calculation but i am facing an issue while setting up the calculation.
Requirement is to sum the value of two Keyfigure, but the twist is to perform the cross calculation .
Offline calculation = KF1(this week/month) + KF2 (next week/month) .i.e H23=H22+I21

(H23 = Column H and Row 23)

When i am trying to do the same, the formula is automatically getting update to H23 = H22+H21 (I21 getting replaced with H21).

Please how can i achieve this calculation dynamically.

Regards,

NC

0 Kudos

alecsandraghita

can you please assist here.
alecsandraghita