Exploring TM1 - a Chartertech Company
Search
Search
Close this search box.

Rules

Reporting
Gautam Narula

How to Calculate SUMIF in TM1

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?

Read More »
Rule Functions
John Vaughan

Rounding in TM1 – The Complete Guide!

ROUND and ROUNDP are often confused and users expect them to behave the same as the Excel function. They are very similar but are different to the Excel treatment. Here is a complete explanation of both functions, a comparison to Excel ROUND and screenshots of the usage of both functions.

Read More »
Feeders
John Vaughan

How to Dynamically Assign Information based on Data Entry

How to create a planning model where users can enter or select variables in one location and TM1 then assigns the data dynamically to all required dimensions. For example, in a budgeting model to plan labour centrally and assign people to cost centres dynamically.

Read More »
Rule Functions
John Vaughan

YEAR Function in TM1: Syntax and Use

The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.

Read More »

Log In