AND and OR logical operators

Options

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
1
1 votes

New · Last Updated

Comments

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!