Key Figure calculation, formula to check for (none) no value in attribute on Planning Object

[vincentverheyen]

In an IBP Key Figure calculation, one can easily make conditional statements based on an Planning Object's attribute value. For example, a conditional statement based on

if the attribute ATTR1's value is: "APPROVED" (converted to uppercase)

as follows:

IF(UPPER(''ATTR1'') = ''APPROVED''...

However, how does one code:

if the attribute ATTR1's value is: empty (none)

Can we use any of the usual suspects in this case, such as IF(ISNULL(... or ISBLANK(... et cetera?

[avijit · Accepted solution]

Dear,

You may use:

IF(ISNULL(ATTR1),...,...)

When Editing the Calculation, do not use Single Quotes ('') around the Attribute ID. Upon saving the changes, system will encapsulate the required quotes.

Since, the requirement is to look for NULL value, using a UPPER() is not required.

Best regards,
Avijit

[lokesh_reddy4]

Hi, Use

IF(ISNULL(XX),YY,ZZ)

Br,

Lokesh

[vincentverheyen]

Hi lokeshreddy7, thank you. Do you mean this generic formally will equally work, not only for the checking on whether or not a KF's value is NULL, but also for checking on whether an attribute's value is (none)? Do you mean it will work as such:

IF(ISNULL(''ATTR1''),...,...)