APO-DP Macro formula query

[Former Member]

Hi SAP experts,

I'm having a problem in a planning book in which a negative value appears in a consumed AATP in which negative value should not occur. Because of this a customised functionality was affected. This was the formula of the macro:

Carry Over Alloc w = MAX (AATPw-1;0) + HUB Inventory Sat w

Thus MAX (AATPw-1;0) means that if the value is in negative, the macro will calculate this as zero? For example -150 is the value of AATPw-1, Hub inventory is 200. Thus the macro having a automatically change this -150 to 0 and calculating it to:

Carry Over Alloc w = 0 + 200

Please help on what MAX (AATPw-1;0) means.

Thanks in advance!

Raymond

[Former Member]

Hello there...yes you are right...the function Max(1....n) will return the maximum value in the range 1....n and so from your example if u have -150 to 0 as your interval then Max would return 0..

Hope this helps!

Thanks!

[Former Member]

Thank you so much..

[Former Member]

would be great if you can close this thread if your question is solved

Thanks!