Help needed with Macro

[Former Member]

Hi all,

I have a macro, to recalculate a key figure:-

Row: DEMAND MODIFICATION ( Frm  M 01.2014 ) =

     Row: PREVIOUS CONSENSUS DEMAND PLAN ( Frm  M 01.2014 )

     -

     Row: Growth NY ( Frm  M 01.2014 )

     -

     Row: STATISTICAL FORECAST ( Frm  M 01.2014 )

     -

     Row: PROMOTION ( Frm  M 01.2014 )

     -

     Row: SALES MODIFICATION ( Frm  M 01.2014 )

     -

     Row: PLCM ( Frm  M 01.2014 )

     -

     Row: CUSTOMER MODIFICATION ( Frm  M 01.2014 )

now that want to modify to exclude the blank values in the Previous Consensus demand plan, so that it does not take the blank values of previous consensus demand plan while calculating.

[former_member187488 · Accepted solution]

Hi, you can just add a IF condition to judge whether Row: DEMAND MODIFICATION = 0. If this key figure is set to "zero allowed", you should also take care of the initial case according to note 1068603.

[satish_waghmare3]

Hello Rorie,

Please see below sample macro in which IS_INITIAL function is used to check if a key figure value is initial or not.  If Key figure value is blank then IS_INITIAL function will return value as "1" else it will return "0"

Also click on below link to open a document for more details on IS_INITAL

Below SAP Note suggested by Ada is very helpful too.

1068603  - Handling of initial key figure values using macros

Hope this will help.

Thank you

Satish Waghmare

[Former Member]

Hello Ada and Satish,

Thank you.

how is it possible to skip the above steps , once i have the "IF" condition with IS_INITIAL.

i have the all the steps performed to recalculate a KF and then
" IF" the  KF is blank then i need to skip all those steps.

Thanks.

[Former Member]

Hi

You can place IF.......ENDIF statements around a sequence of steps