APO- DP macro help

[Former Member]

Hi Gurus,

I'm quite new to APO Macro Workbench, that's why I would ask for your help.

I try to create a macro where I have 2 key figures.

The macro should calculate the differentiation between the 2 values and show an alert in case key figure 2 is xx% higher or lower than key figure 1.

Do you have any idea how to build this up?

Many thanks in advance!

Br,

Roland

[jagannadhb]

Hi Ronald,

Assuming the xx% is 2%, here is a simple example

Guess this helps.

Regards,

JB

[marianoc]

Hi Roland,

If you want to show the cell in a different color, you can use function CELL_BG(X). X is the color number.

Function

Explanation

CELL_BG()

CELL_BG( X ) sets the background color of a cell to:, blue if X = 1, white if X = 2, yellow if X = 3, cyan if X = 4, green if X = 5, red if X = 6, magenta if X = 7, deep blue if X = 8, gray if X = 9, bright yellow if X = 10, intensive cyan if X = 11, intensive green if X = 12, deep red if X = 13, deep magenta if X = 14. If you set X = 0, the current color is not changed. You can apply this function to arow or cell of the planning table (generally a row). In the attributes of the row / cell you must set theScope of change to Attributes. For example, Macro1  |----- Step1 (1 iteration)  |----- CELL ( sales ; period ) |----- Cell_BG( 6 )

Here you have an example:

If you want to generate an alert to see later in /SAPAPO/AMON1, then here you have an example:

Thanks and Regards,

Mariano

[marianoc]

Hi Roland,

Do you have any futher question.

If not, please close the thread.

Kind Regards,

Mariano