Search
Search

# Rule Functions

Reporting

### How to Calculate SUMIF in TM1

IBM does not provide a native function to calculate SUMIF in TM1. How do I calculate SUMIF in TM1 and perform a sum of values based on a user input?

Rule Functions

### TM1 RoundUp Function: Method, Syntax and Use

The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple method to achieve exactly the same outcome. TM1 RoundUp Method The method

Rule Functions

### INT in TM1: Finding the Largest Integer Less Than or Equal To a Specified Value

The INT function allows you to return the nearest integer less than or equal to a specified value. Syntax of INT The syntax of the INT function is simply: where:

Rule Functions

### How to find the Largest of Two Values in TM1: MAX Function: Syntax and Use

The Max function will deliver to you the largest of two numbers. For example, if you have 50 and 100, using the MAX function will return 100. Syntax of MAX

Rule Functions

### ELWEIGHT TM1 Function: How to Use, Syntax & Example

Ever wondered how you can use the weight assigned to an element in a hierarchy in a rule or turbo integrator process? Well, ELWEIGHT allows you to do just that!

Rule Functions

### DAY TM1 Function: How to Use, Syntax and Example

The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY (’24-09-18′) will return the number 18.

Rule Functions

### ELCOMP TM1 Function: How to Use and Syntax

In TM1, ELCOMP returns the child element at a specified numeric position of a parent. Full syntax and explanation for use.

Rule Functions

### ELCOMPN TM1 Function: How to Use & Syntax

In TM1 and Planning Analytics, ELCOMPN returns the number of children an element has Full syntax and explanation for use.

### TM1 FEEDSTRINGS: What Is It and How Do You Use It

You’ve probably have across a rule that has SKIPCHECK at the start. You might have noticed that also, quite often, is another line of code right next to it in

Rule Functions

### ELISPAR TM1 Function: Use and Syntax

ELISPAR tests if an element is a direct child of a parent in a dimension in TM1. Here we explain how to use it, provide examples and compare it to ELISANC.

Rule Functions

### ConsolidatedAvg TM1 Function: How to Use, Example, and Syntax

ConsolidatedAvg is used to calculate the average of rolled up values at the consolidated level. Here it’s explained in detail with a worked rule example.

Rule Functions

### Rounding in TM1 – The Complete Guide!

ROUND and ROUNDP are often confused and users expect them to behave the same as the Excel function. They are very similar but are different to the Excel treatment. Here is a complete explanation of both functions, a comparison to Excel ROUND and screenshots of the usage of both functions.

Feeders

How to create a planning model where users can enter or select variables in one location and TM1 then assigns the data dynamically to all required dimensions. For example, in a budgeting model to plan labour centrally and assign people to cost centres dynamically.

Rule Functions

### YEAR Function in TM1: Syntax and Use

The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

### DType Function in TM1: Syntax and Use

Use, syntax and example of the DType function in TM1 and Planning Analytics. In this post we explain the use of the DType function and give an example of how it can be used to determine the cell type of a cube when loading data via a Turbo Integrator process.

Rule Functions

### MONTH Function in TM1: Syntax and Use

The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

### How to Convert a Numeric Date to a String using the DATE Function in TM1

The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 , 1); will return the string ‘1998-03-09’.

### How to use Operators in TM1 Rule IF Statements

Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.

Feeders

### What is Skipcheck in TM1?

Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. For example, you have 30 days in a month and data in only

### Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is really easy!  Just use the pipe ( ” | ” ) between two