Skip to Content
Author's profile photo Rahul Handa

Macro – Pop-Up Usage for Input & Calculation

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.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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..!


      Author's profile photo Rahul Handa
      Rahul Handa
      Blog Post Author


      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.



      Author's profile photo S Ghosh
      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.

      Author's profile photo Rahul Handa
      Rahul Handa
      Blog 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.

      Author's profile photo Akhilesh Agarwal
      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