Skip to Content
0

3 Month Average Macro

May 31, 2017 at 07:28 PM

70

avatar image
Former Member

Hello Experts,

I ahve crated a macro for 3 Months Average for a Key Figure.

My requirement is to show the result in Current month in another KF and copy the same value to future periods and aswell as the same 3M Avg to another KF from current month to future periods too as this is a dis-agg KF, and my stat is disaggregated based on this KF.

Screenshot of macro and requirement shared.

Please provide your inputs, Hoping for some advise/ guidance

TIA

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers