Rule Examples

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.

Accumulating Values in TM1 for Rolling Forecast/Cashflow

Posted on Feb 27, 2015 by John

How do I take a value and then use it for all periods from now on in a Rolling Forecast environment?  In other words, how do I accumulate (or calculate…

Empty Square Brackets in a TM1 Rule

Posted on Oct 26, 2014 by John

Ever wondered why some TM1 rules have empty square brackets (like this [ ] )? Well MafiaMan just explained it to me.  Really simple, but also extraordinarily powerful.  What it means is…

NUMBR TM1 Function: Use and Syntax

Posted on Sep 3, 2014 by John

From time to time we need to convert a string (or text) into a value. If we were in Excel, we would use the Value function. Unfortunately, “Value” doesn’t work…

3 Types of Rules TM1 Developers should know

Posted on Aug 17, 2011 by Ben Hill

We’ve gone through our notes for training our staff and aside from basic equation rules we have listed three classes of common rules which TM1 Developers should be familiar with….

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!