Exploring TM1 - a Chartertech Company
Close this search box.

How to use Operators in TM1 Rule IF Statements

Do you need to create an IF expression in a TM1 rule with a logical operator? To create something that is like an AND or OR from SQL but do it in a Rule? Look no further!

If, however, you are looking for IF operators for a Turbo Integrator process, please check this post.

TM1 Rule Operators

There are some very useful operators available in TM1 Rules. Use

  • For OR, use a percent sign: %
  • For AND, use and ampersand: &

Example in Rules

Here is an example of creating a rule that uses “&” operator to check if multiple elements are zero and if so, return a 0 and otherwise return a 1.

['Below Meet or Exceed'] = C: IF ( ( ['Exceeds Standard'] = 0 &  ['Meets Standard or No Activity'] = 0 & ['Below Standard'] = 0) , 0
 , 1

This says that if the elements “Exceeds Standard”, “Meets Standard” or “No Activity or Below Standard” are all equal to zero, then set the consolidation of “Below Meet or Exceed” to 0 and if any of them are not equal to zero, then return 1.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In