FORMULA LANGUAGE
Examples: @Max
1. This example returns 3.
@Max(1;3)
2. This example returns 99;6;7;8.
@Max(99:2:3;5:6:7:8)
3. This example returns -2; 45; 54.
@Max((-2.6):45:(-25);(-2):(-50):54)
4. This formula finds the larger of the values in the fields named Commission and Salary, and compares the value to 50,000; if it is larger than 50,000, the Bonus field is changed to 0; if it is smaller than 50,000, Bonus becomes 10% of the value in the Salary field.
FIELD Bonus:=@If(@Max(Commission;Salary)>50000; 0; (0.10 * Salary));
5. This example returns 99.
@Max(99 : 2 : 3)
6. This formula compares the corresponding sales figures in the jian_yrtotal and julie_yrtotal fields (which contain number lists) and returns a number list containing the larger of the two figures per element. If there are seven elements in the jian_yrtotal field and five in the julie_yrtotal field, this formula only returns the five largest numbers. Unlike the default behavior, which is to first repeat the fifth element until the list lengths are equal and then compare all seven corresponding elements in the lists, it does not repeat the fifth number in the julie_yrtotal field twice before performing the comparison.
tjian := @Count(jian_yrtotal);
tjulie := @Count(julie_yrtotal);
dif := (tjian - tjulie);
result := @If(@Sign(dif) = -1;@Subset(julie_yrtotal;(tjulie - @Abs(dif)));
@Subset(jian_yrtotal;(tjian - dif)));
@IfError(@If(@Sign(dif) = -1;
@Max(jian_yrtotal;result);@Max(result;julie_yrtotal));"One of your list fields is empty")
See Also
@Max
Glossary
Help on Help
Open Full Help Window
Glossary
Help on Help
Open Full Help Window