if is null for alert keyfigures

[Former Member]

Hi all,

Can we use two if is null conditions for alert definitions??

Something like:

If(isnull(price), if(isnull(fcst),0,1),1)

I have configured this logic. But somehow doesnot seem to be wrkng fine.

Can someone help me here.??

Regards,

Manaswini

[Irmi_Kuntze]

You can use OR or AND, depending on what you want to achieve

For example:

IF(    (  ISNULL(price)   OR   ISNULL(fcst)   )  ,    0,    1)

...and the same for AND instead of OR...

[Alecsandra]

Hi Manaswini,

What do you try to achieve? When shall the alert be triggered?

The above syntax would activate the alert when:

a) PRICE is not NULL

b) PRICE is NULL and FORECAST is not NULL

Regards

Alecsandra

[Former Member]

Hi Alecsandra,

i want an alert for only "when price is there when fcst is not there" How can i achieve only this

Regards,

Manaswini

[Alecsandra]

Hi Manaswini,

I see at least 2 options:

IF(ISNULL(PRICE), 0, IF(ISNULL(FCST), 1, 0))

OR

IF(ISNULL(FCST) AND PRICE > 0, 1, 0)

--> here i assumed that when there is PRICE, it is higher than 0. If you want to include also 0 case you can build it like AND (PRICE >0 OR PRICE = 0)

Regards

Alecsandra