APO DP Macro for Blank Values

[Former Member]

HI all

In SCM 5.0 the system now distinguishes between 0 values and Blank values.

I am trying to get a macro to run if a value in DP is Blank (not Zero)

I cannot find a function in the Macro builder to do this.

Can anyone help?

regards

[former_member583013 · Accepted solution]

Hi,

The macro function which differentiate blank and zero is

IS_INITIAL.You can find

In SCM 5.0 release In order to distinguishing between zero and

initial or excel upload in planning grid you will need to use the new

frontend provided in note 889989 in additition to GUI 6.40.

Alternatively you can apply the new GUI 7.1 as mentioned in the note.

Regards,

Sunitha.

[former_member583013]

somemore information on IS_INITIAL macro funtion

IS_INITIAL()

Syntax

IS_INITIAL( Key Figure )

Key Figure: Row, column, or cell element (data source = row attributes)

Description

The IS_INITIAL function returns the value 1 if the cell is initial. (The column results from the current step iteration; the row is determined by the Key Figure parameter.) Apply this function for key figures that can distinguish between zero values and initial values. This function is not available if the compatibility mode is activated for the macro book.