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.
TODAY TM1 Function: Syntax and How to Use
TODAY simply returns the current system date as a string in the form ‘yy-mm-dd’, or if you want, in the format ‘yyyy-mm-dd’. Syntax of TODAY The syntax is Today (…
STR TM1 Function: Syntax and Use
STR is a TM1 function that converts a number to string. It is very similar to the Excel function “TEXT”, except you don’t need to specify the format of the…
How to Convert a String Date to a Numeric Date in using the DayNo TM1 Function
Here we are going to explain how to use the DAYNO TM1 function to convert a date as a string into a serial number. For example, to convert 14-Apr-2016 into…
IF Rules in TM1: How to Use, Syntax and Examples
IF() is a function that can be used to test if an expression is true so that you can then differentially execute a rule based on the outcome of the IF statement….
RIGHT TM1 Function: Use and Syntax
The RIGHT function from Excel does not exist in TM1, but here’s how to do it anyway! We need to use a combination of SUBST and LONG functions instead. It…
LONG TM1 Function: Syntax and Use
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
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: How to Use and Syntax within TI and Rules
ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element in a dimension in TM1. Note this is not AttrGetN! That function…
ELLEV TM1 Function: Use and Syntax
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
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…
Need help with TM1?
We're here for you
Keen to chat? Book a discovery call!
