on 07-07-2015 10:34 AM
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 ?
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Achal,
What error are you getting?
Best regards
Rinju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.