SAP IBP Alert Key Figure Calculation expression is invalid for Not Equal <> Statement

[leventoturak]

Hello experts.

i am trying to create a new Alert Key Figure (HASOUTLIER) and using the following calculation with "not equal" statement / operator.

The Key Figure "DIFCORRCLEANSALES" has been calculated as following.

I am getting the following error by the activation of the planning area.

Can you give me more details about the "Not Equal (<>)" statement for the Alert Key Figure Calculation?

What should be wrong with the syntax of "IF <>" statement?

Thanks and Regards

[Irmi_Kuntze · Accepted solution]

Hey
Why don't you just switch around the calculation:
Instead of
IF( "KF@LEVEL" <> 0 , 1 , 0 )
change to
IF( "KF@LEVEL" = 0 , 0 , 1 )

And you have OR and NOT and ...

And don't forget to check on ISNULL …

In the model config guide you will find a sub-chapter "Commonly Used Functions and Expressions" (Key Figures --> Key Figure Calculations).
Here you will find > and < and so on, but not <>….

Irmi

[leventoturak · Accepted solution]

Thanks. It is working with IF( "KF@LEVEL" = 0 , 0 , 1 )

[piyush_parekh]

Hi,

You can use != instead of <> for building not equal to logic.

Regards,

Piyush Parekh