AND and OR logical operators
In our work we need to frequently use several layers of nested IF THEN ELSE statements. These could be greatly streamlined by introducing IF and OR logical operators to Anaplan. For example:
IF A = 1 THEN IF B = 2 THEN TRUE ELSE 0 ELSE 0 could be replaced with IF AND(A = 1, B =2) THEN TRUE.
In this context, these operators are defined as:
- AND - a statement that evaluates two or more Booleans and returns TRUE when all statements are true
- OR - a statement that evaluates two or more Booleans and returns TRUE when any statement is true
Tagged:
1
Comments
-
0
-
@rob_marshall Yes, that works but on some of models the requirement to add multiple such Booleans greatly expands total cell count.
0 -
0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!