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?

[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''),...,...)