Most of you know the concept of an IF statement within TurboIntegrator
| IF (expression); statement1; ENDIF; |
… and most of you also know the concept of nested-IF statements
| IF (expression); statement1; ELSEIF (expression); statement2; ENDIF; |
… and most of you also know the concept of generically using an ELSE command as a catch-all
| IF (expression); statement1; ELSEIF (expression); statement2; ELSE; statement3; ENDIF; |
But did you know that Planning Analytics has a maximum number of nests that can be included within a TurboIntegrator process? You can nest up to 20 ELSEIF/ELSE statements in a process. If you exceed 20 nested statements then you will receive an error when attempting to save the process.
If you come across situations where you are using a lost of nested IF statements, then there may be a way to re-assess the expressions that are being used. Give us a call!
IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters! You can also sign up to get our Planning Analytics Tips & Tricks sent directly to your inbox!
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula
IBM Planning Analytics Tips & Tricks: IFERROR
IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions
