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:

MAX ( number1, number2);


  • number1 is the first number to be evaluated, and
  • number2 is the second number to be evaluated

Example of MAX

A simple example is:

MAX ( 100, 50);

This will return 100.


MAX can be used in both TI’s and Rules.

It can only be used to evaluate two values, not a series of numbers.

You might also like