Dear Macro Experts
I have done this syntactically correct 2 step macro. I have seen similar threads where either questions were open ended or replies were.
So posting my version.
Result row = Average of some periods of another KF in same planning book
Result row < 0
Set Result row = 0
This macro is ZEROing out everything in the result row at any level of drill down/up
Another key figure series: M1=20, M2=30, M3=40, M=➖ 55
Result row = Average 3 periods M3- 20 + 30 + 40 divide 3 = 30, M4 = 30+40-55/3 = ➖5
Now I expect M4 to be equal to 0 is the same result row whatever be the CVC levels loaded and saved. BUT I see all values in result row set to 0. Tried the macro test utility setting this as defaut, level change and directly executable macro but in all cases I see only zero
Question: Where am I going wrong on such simple syntax
Prod. fix issue. Quick response appreciated.