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 […]