Macro - multiply numbers at two different levels

[Former Member]

Hi Folks,

I am trying to write a macro which takes KF at a detailed level and multiplies it with another key figure at a different level of aggregation. Any ideas in this direction will help.

A - B

KF 1 = 10 %

A - C

Kf 1 = 20%

A

KF 2 = 100

I want to write a macro that gives following result

A - B

KF3 = 10 ( 10% * 100)

A - C

KF3 = 20 ( 20% * 100)

Regards,

Sachin

Edited by: Sachin Ganesh Shetty on Feb 12, 2009 4:57 AM

[Former Member · Accepted solution]

Hi,

I had a similar requirement of running a macro at 5 level and use a data at 3 level as one of the inputs.

what i did was i wrote a Z function module which called /sapapo/msdp_data_read and retrieved the value at 3 level.

Thus i was able to extract a 3 level value and use it to run a macro at 5 level.

Please let me know if this helps.