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 |