Skip to content

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.

RIGHT TM1 Function: Use and Syntax

Posted on Feb 25, 2016 by John

The RIGHT function from Excel does not exist in TM1. We need to use a combination of SUBST and LONG functions instead. Where you have a formula in Excel in A2…

LONG TM1 Function: Syntax and Use

Posted on Feb 25, 2016 by John

The LONG function in TM1 returns the length of a string as a value.  It is similar to the LEN functions available in both Excel and SQL Server. Syntax of…

LEFT TM1 Function: Use and Syntax

Posted on Feb 25, 2016 by John

The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you have a formula in Excel in A2 that is = LEFT (…

ATTRN TM1 Function: Use and Syntax within TI and Rules

Posted on Dec 21, 2015 by John

ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element in a dimension in TM1. Syntax of ATTRN The syntax is ATTRN…

ELLEV TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The ELLEV function returns the numeric value of the level for an element in a dimension in TM1. Syntax The syntax is ELLEV(dimension, element); where: dimension, is the dimension you are…

DIMNM TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The TM1 function DIMNM returns the name of an element from its index in a TM1 dimension. Each element in a TM1 dimension has an index number.  This is internal to…

DimSiz TM1 Function: Use and Syntax

Posted on Mar 30, 2015 by John

The TM1 function DimSiz returns the total number of elements in a TM1 dimension. Syntax of DimSiz The syntax is DIMSIZ(dimension); where dimension is the dimension you want to get the total…

SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax

Posted on Mar 1, 2015 by John

The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that it allows you to select a group of characters of  a specified…

Scan TM1 Function: Syntax and Use

Posted on Oct 29, 2014 by John

Scan is a TM1 function that find the numeric position of the first instance of a specified substring within a string. If the substring is not found, it returns zero. It is…

Using STET and CONTINUE in TM1 Rules

Posted on Oct 26, 2014 by John

Often we want to tell TM1 to ignore this cell and move onto the next cell if a certain condition is met (or not met).  To do this we would…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles