Rule Functions

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

How to Calculate SUMIF in TM1

Posted on Aug 30, 2023 by Gautam Narula

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

TM1 RoundUp Function: Method, Syntax and Use

Posted on Mar 7, 2022 by Andrew Walker

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…

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

Posted on Mar 7, 2022 by John

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: INT…

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

Posted on Mar 7, 2022 by John

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…

ELWEIGHT TM1 Function: How to Use, Syntax & Example

Posted on Nov 16, 2021 by John

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

DAY TM1 Function: How to Use, Syntax and Example

Posted on Sep 13, 2021 by John

The DAY function in TM1 is almost exactly the same as the DAY function in Excel, in that it returns the day of the month from a date. It is…

ELCOMP TM1 Function: How to Use and Syntax

Posted on Apr 22, 2021 by John

The ELCOMP function in TM1 is used to derive the element at a specific position as the child of a parent. Syntax The syntax is: ELCOMP(DimName, Parent, Position) where: DimName…

ELCOMPN TM1 Function: How to Use & Syntax

Posted on Apr 21, 2021 by John

The ELCOMPN function in TM1 is used to derive number of an child elements of a parent. Syntax The syntax is: ELCOMPN(DimName, Element) where: DimName is the dimension you are…

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

Posted on Jan 4, 2021 by John

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…

ELISPAR TM1 Function: Use and Syntax

Posted on Jul 21, 2020 by John

ELISPAR stands for ELelemnt IS PARent, in other words, is one element in a dimension a parent of another. It is testing to see if one element is the child of…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!