APO- Macros

[Former Member]

Hi All,

I was trying to use macro function SUM_CALC().

My Req is,

I wants to sum up a auxiliary key figures for 10 periods and check the sum, if my sum is > 0 I will execute a alert.

New step : ( 1 Iterations :22.05.2008;22.05.2008 )

IF

Row total is 1

SUM(

Row: Row total ( Frm 22.05.2008 )

)

= 0

Add : No data in key figures [ New alert ]

ENDIF

Guide me if I am doing wrong, and also please suggest any easy method

With regards,

Sreerama

[Former Member · Accepted solution]

Hi aravind,

I don't think sum_calc() should be used for ur requirement, as

SUM_CALC( key figure ) calculates the sum of all detail levels of the specified key figure.

Also the example logic that you have given nowhere shows usage of the function.

I think using the below logic should work for you.

Step1: 1 iteration Column 1 ; Column 1

IF

Condition for message

SUM(

Area [( Key figure 1 (Column 1); Key figure 1 (Column 2)]

)>0

Information [Message1]

ELSE

Information [Message2]

ENDIF

Hope this helps

Regards

Ankur

[Former Member · Accepted solution]

Hi,

thanks for the quick response, Here I cant use Sum as you suggested because my results which I wants to sum are in Auxiliary key figure and functions wont recognize Auxiliary key figure.

To be concise, I wants to add all the cells in my Auxiliary key figure row and check is it grater than or less than 0.

suggest me any macro function.

With regards,

Sreerama

[Former Member · Accepted solution]

copy Aux KF to real KF and use function SUM incase function sum does not work with Aux KF.

[Former Member]

Thanks,

Problen solved with Maheshwer's help.

Regards

Sreerama