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.
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.
Select three columns as shown below:
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.
As you can see, below the production forecast is 1,5 times of composite forecast. Save the data in planning book.
Hope this helps in your day to day projects.