Skip to Content
0
Former Member
Apr 04, 2012 at 06:14 AM

Macro quick check..negative values

106 Views

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.

Step1

Result row = Average of some periods of another KF in same planning book

Step2

If

Result row < 0

Set Result row = 0

endif

This macro is ZEROing out everything in the result row at any level of drill down/up

Example

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

Scrshot attached

Prod. fix issue. Quick response appreciated.

Guru

Attachments

Macrononneg.png (22.5 kB)