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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply