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.
ConsolidatedAvg TM1 Function: How to Use, Example, and Syntax
ConsolidatedAvg is used to calculate a single consolidated average value of child values at the n level. For example, if you have three child elements with 10, 15 and 11…
Rounding in TM1 – The Complete Guide!
Rounding is where we remove decimal places from a number and force the last remaining decimal place or integer up or down depending on the source value. In TM1, there…
How to Dynamically Assign Information based on Data Entry
Have you ever wondered how to have a flat list in TM1 and then send values off to different elements on various dimensions depending on what is entered in the…
YEAR Function in TM1: Syntax and Use
The Year function in TM1 extracts a numeric version of the year from a text string that represents a date, where the date has been presented in either YYYY-MM-DD or YY-MM-DD…
DType Function in TM1: Syntax and Use
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
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….
How to Convert a Numeric Date to a String using the DATE Function in TM1
The DATE function in TM1 converts a serial date (or numeric date) to a text version of the date in either YYYY-MM-DD or YY-MM-DD format. This is the opposite of…
How to use Operators in TM1 Rule IF Statements
Do you need to create an IF expression in a TM1 rule with a logical operator? To create something that is like an AND or OR from SQL but do…
What is Skipcheck in TM1?
Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. For example, you have 30 days in a month and data in only…
Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule
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…
Need help with TM1?
We're here for you
Keen to chat? Book a discovery call!
