Doubt in Macro functions (SCM 5.0)

[Former Member]

Hi All,

Can someone please tell me the macro function to find out the non zero values in planning book (row components) i.e which bucket in the planning book has non zero values.

Also is there any macro function available for EXIT (or any other function which can be used to get the same functionality).

We are on SCM 5.0 version.

I ll appreciate your help with rewarding points.

Thanks in advance..

Jagadeesh

[Former Member · Accepted solution]

Jagadeesh,

We use the IS_INITIAL macro function to tell if a cell in a row is blank:

Step: Check For Blanks (24 iterations P 01/2008; P 12/2010)

IF

<Condition>

IS_INITIAL(

Row: Row That Is Being Checked ( Frm 01/2008 )

) = 1

<Action>

Change the background color to Red

ELSE

ENDIF

Prerequisites:

In the macro, you will need to change the attributes of Row That Is Being Checked to 'Row attributes' (it defaults to 'Values').

In the Planning Area settings (/SAPAPO/MSDP_ADMIN) you may want to change the key figure setting for Row That Is Being Checked so that it can tell the difference between ) 0 and nothing (optional). This way you could distinguish a 0 from a blank...

Hope this helps.