TM1 RoundUp Function: Method, Syntax and Use
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 to achieve in TM1 what is available in Excel via the RoundUp function uses the INT function and some clever usage of negatives. Here it […]
INT in TM1: Finding the Largest Integer Less Than or Equal To a Specified Value
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: value is the number you are assessing Example An example is This will return 11. An example of a negative number is This will return […]
How to find the Largest of Two Values in TM1: MAX Function: Syntax and Use
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 The syntax of the MAX function is: where: number1 is the first number to be evaluated, and number2 is the second number to be evaluated […]