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.

DType Function in TM1: Syntax and Use

Posted on Apr 13, 2018 by John

One of the team were just writing a TI to load a text file into TM1. It was all working swimmingly until he tried to load a string (a 3…

MONTH Function in TM1: Syntax and Use

Posted on Dec 5, 2017 by John

The Month function in TM1 extracts a numeric version of month from a text string that represents a date, where the date has been presented in either YYYY-MM-DD or YY-MM-DD format….

Date Function in TM1: Syntax and Use

Posted on Oct 31, 2017 by John

The DATE function in TM1 converts a serial date to a text version of the date in either YYYY-MM-DD or YY-MM-DD format. For example, let’s say you have a date…

Operators in TM1 Rule IF Statements

Posted on Mar 22, 2017 by John

Do you need to create an IF expression in a TM1 rule with a logical operator? To create something that is like and AND or OR from SQL but do…

What is Skipcheck in TM1?

Posted on Oct 31, 2016 by John

Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. So if you had 30 days in a month and data in only…

Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

Posted on Oct 27, 2016 by John

I was asked the other day how to concatenate some information in TM1. Joining two text fields is really easy!  Just use the pipe ( ” | ” ) between two…

TODAY TM1 Function: Syntax and Use

Posted on Jun 9, 2016 by John

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

Posted on Jun 9, 2016 by John

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…

DayNo TM1 Function: Use and Syntax

Posted on Apr 14, 2016 by John

Yesterday I was doing some work on an inventory forecasting system.  I had Year, Month and Day dimensions and needed to bring through Actuals for all days up until yesterday….

IF() TM1 Rule Function: Use and Syntax

Posted on Apr 13, 2016 by John

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

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!