Min / Max Calculation for Formulas
Advanced Number Field adds support for the min() and the max() formula, which can be used in Number Field calculations. It returns the lowest or the highest value from a list of merge tags.
Using Min() and Max() calculations
Enable Calculations in the settings of a number field. Use Min or Max within the formula with a comma-separated list of number field merge tags. Note that calculations within Min() or Max() are not supported.
Supported syntax examples
Max({Number:1}, {Number:2}, {Number:3})
( Min({Number:1}, {Number:2}, {Number:3}) + 10 ) / 2
Not supported
Max({Number:1} * 2, {Number:2}, {Number:3})
Max( Min( {Number:1}, {Number:2} ), {Number:3})
Last updated: 02-03-2022