About NULL recognition of macro function in SCM7.0

[HiroshiMori]

Hi expert.

I have question regarding NULL value recognition of macro function in SCM7.0

I want to know how to express NULL value in macro calculation.

I already tried [= NULL], but does not working.

Best regards

Hinoki

[HiroshiMori · Accepted solution]

Hi expert.

I have question regarding NULL value recognition of macro function in SCM7.0

I want to know how to express NULL value in macro calculation.

I already tried [= NULL], but does not working.

Best regards

Hinoki from Japan

[Former Member · Accepted solution]

Hi Hinoki,

You have to put it a little differently.

IS_NULL(column_name) or IS_INITIAL(column_name). A return value of 1 means it is null.

THanks

Mani

[Former Member · Accepted solution]

Hinoki,

As Mani has suggested use the following function:

IS_INITIAL(

Row: <Your Row Name>

) = 1

BUT MAKE SURE YOU USE "ROW ATTRIBUTES" IN THE ATTRIBUTES FIELD OF <Your Row Name>

1= NULL or Initial

0 = Not Null