Internal table like functionality in macro

[Former Member]

Hi all,

Can somebody help me understand how to write a macro to depict internal table/array of values?

I have a 2 step macro. First step runs for all past and based on some condition, I need to identify those key figure values, that qualify and put them in an array/vector/internal table. In 2nd Step, I need to find average of those identified values in the past and alert if its > X.

I am unable to get the vector or the auxilary table worked for me. Please help!

thanks

Vijay

[rajkj · Accepted solution]

Hi Vijay,

Check the following screenshot of a working alert that uses auxiliary table elements to hold past values and trigger an alert if there is an exception per business logic. This example might give you an idea.

Thanks,
Rajesh