Skip to main content
Planview Customer Success Center

Max Function

Max (arg1 as Object, arg2 as Object, ... as Object) as Object

Category: Math
Description: Returns the greatest value of the arguments
Supported Context: FormulaField And BusinessRules
Parameters:  
arg1 as Object Represents any value type, or reference to a field that will be compared to the other "arg" parameters
arg2 as Object Represents any value type, or reference to a field that will be compared to the other "arg" parameters
... as Object Represents any value type, or reference to a field that will be compared to the other "arg" parameters
Returned value as Object Returns the maximum value of the values provided in the "argx" parameters
Example #1

Create a validation rule that will check whether a work item's due date was updated by setting the work item 'Duration' and which exceeds the parent milestone or project's due date. In such a case, throw an error and block updating the appropriate duration of the work item.

The Evaluation Criteria of this validation rule will be:

IsChanged($Duration) && IsChanged ($DueDate) && Not (IsNULL($Milestone)) && (Max($DueDate, $Milestone.DueDate, $Project.DueDate) = $DueDate)

Tips Validation Rules can be used throughout the entire system and will help in regulating data as per your organizational standards