prashanth

[Former Member]

Hi Gurus,

i am facing a problem to create a alert macro .so please help me out.the scenario as follows:

we have a key figure for account manager i.e ACM KF..the condition is: if the average of previous three months of same ACM KF is 100..for the present month if it exceeds more than 20% of average of three months..an alert should be given. for example if he changes 150 an alert should be given ..please provide me a screen shot.

thanks

prashanth

[rajkj]

Hi Prashanth,

You can try out the following solution.

Step 1: Initialize variables (1 iteration)

//Use ACTION BOX element

VEC_LAYOUTVARIABLE_SET( 'ACM_AREA' ;

ACM key figure area

)

Step 2: Check the previous 3 periods average with current period value (All future iterations)

Aux.Row[i] = 0  // where i = ACT_COLUMN

IF(ACT_COLUMN - 3 > 0 )

Aux. Row[i] = AVG( VEC_LAYOUTVARIABLE( 'ACM_AREA' ; ( ACT_COLUMN - 4 ); (ACT_COLUMN - 1 ) )

Aux. Row[i] = EVAL( ( ABS( ACM[i] - Aux.Row[i] ) / Aux.Row[i] ) * 100 )

ENDIF

Step 3: Delete alerts in context (1 iteration)

Step 4: Check business condition and trigger alert (all iterations)

IF( Aux.Row[i] > 20 )

     //trigger alert

ENDIF

Thanks,

Rajesh