Rule Functions
ELPARN TM1 Function: How to Use and Syntax
ELPARN is a TM1 function for calculating the number of parents an element has. This includes the syntax and examples.
johnv
9-May-2024
ELPARN is a TM1 function for calculating the number of parents an element has. This includes the syntax and examples.
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?
TM1’s security can be as simple or as complex as you need. We tend to start with the broadest possible definition of security and then refine it down to the
The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple method to achieve exactly the same outcome. TM1 RoundUp Method The method
The INT function allows you to return the nearest integer less than or equal to a specified value. Syntax of INT The syntax of the INT function is simply: where:
The Max function will deliver to you the largest of two numbers. For example, if you have 50 and 100, using the MAX function will return 100. Syntax of MAX
Ever wondered how you can use the weight assigned to an element in a hierarchy in a rule or turbo integrator process? Well, ELWEIGHT allows you to do just that!
The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY (’24-09-18′) will return the number 18.
Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.
In TM1, ELCOMP returns the child element at a specified numeric position of a parent. Full syntax and explanation for use.
In TM1 and Planning Analytics, ELCOMPN returns the number of children an element has Full syntax and explanation for use.
Have you ever needed to calculate the value “as at” a point in time? For example, you have an inventory cube and want to show the volume of stock at
You’ve probably have across a rule that has SKIPCHECK at the start. You might have noticed that also, quite often, is another line of code right next to it in
Simple method for cutting down the calculation overhead of TM1 rules for a multi year forecasting model by limiting rule scope.
Need to get a primary element name from an alias in a TM1 Excel report or TM1 Rule? Simple solution for deriving an element principal name in Rules or Excel.
Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.
ELISPAR tests if an element is a direct child of a parent in a dimension in TM1. Here we explain how to use it, provide examples and compare it to ELISANC.
‘@= is used in TM1 for evaluation of operators in TM1 Rules and TI Processes. Here we explain how it is used and give examples for both rules and processes.
ConsolidatedAvg is used to calculate the average of rolled up values at the consolidated level. Here it’s explained in detail with a worked rule example.
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.
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
