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})