cancel
Showing results for 
Search instead for 
Did you mean: 

How many nested IF can be used in a Key Figure syntex in S&OP/IBP

Former Member
0 Kudos


Hi,

I have used IF (nested IF) function 4 times in a key figure syntex. But the Planning area is not getting activated as the activation is failing in creating senarios. Is there any limitation in S&OP/IBP on number of a fuctions which can be used in one syntex ?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The Key figure Syntax is -

   

IF((ISNULL( "KF1@PERPRODCUST" )), 0, (IF ( "KF1@PERPRODCUST"
=0 AND "KF2@PERPRODCUST" > 0), 1, IF ( "KF1@PERPRODCUST"
= 0 ,0, IF(ABS( " KF2@PERPRODCUST" - "KF1@PERPRODCUST" ) /
" KF1@PERPRODCUST" > "KF3@PERPRODCUST" , 1, 0))))

This is an alert key figure. I need an alert if the ABS(KF1- KF2)/KF1 > KF3.Apart from normal condition , I also need alert when KF1 is 0 and KF 2 has some value (greater than 0).

Irmi_Kuntze
Advisor
Advisor
0 Kudos

1) I have worked with same / more number of IF clauses without any issue

2) try in your ABS clause to remove the spare blanks in " KF2@PERPRODCUST" and " KF1@PERPRODCUST"

3) Syntax seems to be correct otherwise and only one planning level PERPRODCUST

    Nevertheless, if you cannot make it work, create helper KF to separate the clauses

Good luck

Irmi


Former Member
0 Kudos

Hi Achal,

What error are you getting?

Best regards

Rinju

Former Member
0 Kudos

Hi Rinju,

The error is - Exception raised from internal error : 2048- Failed to create senario...