cancel
Showing results for 
Search instead for 
Did you mean: 

APO Macro Calculation

Former Member
0 Kudos

Hi Experts,


Would like to seek for your help what is the best way to create a macro where past and future periods are involved.

Ex.

For the current period computation

If period is from last month up to the past periods

KF3= (KF1 / KF2) *10

If period is current to future:

KF3 = (KF1/KF4)*10

Am just starting with macros. Thanks for your help.

Sincerely,

Ria

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ria

I think you can perform the following calculation using iterations in the Macro step.

Please find below few screen shot where you can define different steps for respective horizon. Once you different steps, you can define each condition/calculation which will be performed for that horizon.

Please do let me know if this information helps you.

Thanks

Amol

Former Member
0 Kudos

Hi Amol,

Thanks a lot. Can I reference the macro to a calendar? The problem is that I have monthly and weekly in my calendar.

Thanks again.

Ria

Former Member
0 Kudos

Hi Amol,

Thanks a lot. Can I reference the macro to a calendar? The problem is that I have monthly and weekly in my planning book.

Thanks again.

Ria

Former Member
0 Kudos

Hi

Check you data view, if it´s in Monthly or weekly?

Please try to create the macro as I suggested above , you could also try Date-dependent flag.

If this already answer your question follow How to close a discussion and why

Thanks

Amol

Former Member
0 Kudos

Thanks Amol!

Answers (0)