Skip to Content

In regard to following macro Macro – To Create Pop-Up for Input here is an example how to use macro for input and calculation (pop-up). Continuing from the example, let’s define further macro:

Use functions COLUMN_MARKED & LAYOUTVAR_VALUE to explore this functionality. In our case we will mention value X=1 which means if columns selected then perform following action.

Macro 1.JPG

Activate & save the macro. Let’s go to planning book. Here we see the same icon for this macro. In below case both forecast are same as of now.

Macro 1.JPG

Select three columns as shown below:

Macro 1.JPG

Now click the icon for the macro. This will give a pop-up for value. Now, in below example I will put 150% for calculation and press continue.

Macro 1.JPG

As you can see, below the production forecast is 1,5 times of composite forecast. Save the data in planning book.

Macro 1.JPG

Hope this helps in your day to day projects.

To report this post you need to login first.

5 Comments

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

  1. AMOL TAD

    This is super Rahul

    Just a question, can we do this activity for multiple article at the same time.

    Generally we are restricted to maintain/update the values at detailed level only but is this functionality can be enabled to perform changes at aggregate level. If yes it would be great..!

    Amol

    (0) 
    1. Rahul Handa Post author

      Amol,

      This depends upon the aggregated level on which you are planning. Example material & location is lowest level. If I want to do the same at material level (where er have multiple locations for the same material) then I need to load data at material level, select columns and execute macro.

      Same way you can do for multiple articles/materials. Try to create the same and play with aggregated level in planning book.

      Regards

      Rahul

      (0) 
  2. S Ghosh

    Hi Rahul,

    I am trying to use DEMAND_CALC() function. Could you please throw some light on this piece.

    I want to find out those SKUs for which Demand is 0 . Also suggest if there is any other functionality by which I can Achieve it.

    (0) 
    1. Rahul Handa Post author

      Hi Suma,

      I don’t have system next to me, but if I recall this function is for calculating the demand for period mentioned in product master (forecast horizon).

      For your requirement you can check below link. In condition put if it’s equal to ZERO it should change color of the cell to red.

      Macro – Set Background Color of a Cell

      Let me know if it helped.

      (0) 
  3. Akhilesh Agarwal

    Hi Rahul,

    Need you help.

    I have a requirement  where in Demand Planning book we have to show dates in the Key figure.

    for eg

    KF1 should show the Bucket start date say ie if the Bucket is from 07/02/2017 to 14/02/2017 then in the Planning book against the KF1 we should see values(07022017 OR 07-Feb-2017) of the start date .

    Can you please advise

    (0) 

Leave a Reply