Step 1: Log on to SAP IBP Excel Add-in
Step 2: Open the existing template or open new template.
Step 3: Create the local member for as following scenario
= Actuals Qty – Actuals Qty Prior Yr
Navigate to Planning Template “Advanced” -> Click on “EPM Editor Report”
Select the “Local members”
Local member Properties
Select Enable Option
Name: Enter Local Member Name
Description: Enter the description
Formula:
=INDIRECT(ADDRESS(ROW()-2,COLUMN()))INDIRECT(ADDRESS(ROW()-1,COLUMN()))
Select radio button Insert After
Attached to
Select Member
After added member, click on Add button in Actions.
Click on “OK” button. Created local member added to planning template.
Save as new template or update the existing template.
Note: Formula is based on the business requirement. This process to enable Local Member only.
Best Regards,
Lingaiah