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…

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….

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…


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…

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.


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.

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,…

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.

ConsolidatedAvg TM1 Function: Syntax, Use and Examples

ConsolidatedAvg is used to calculate a single consolidated average value of child values at the n level. For…

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