Rules

Reporting Case Studies, Rule Functions

How to Calculate SUMIF in TM1

IBM does not provide a native function to calculate SUMIF in TM1. How do I calculate SUMIF in…

Rule Case Studies, Security

TM1 Cell Security: How To Do It and Best Practices

TM1’s security can be as simple or as complex as you need. We tend to start with the…

Rule Functions, TI 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…

Rule Functions, TI 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….

Rule Functions, TI 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…

Rule Functions, TI 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…

Rule Functions, TI 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 (’21-09-18′) will return the number 18.

Picklists, Rule Best Practices, TM1 Case Studies

Cascading Picklists in TM1 – How to Create in 4 Steps

Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.

Rule Functions, TI 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, TI 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.

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement