In a filter (or function) choose the minimal of two calculations

#1

E.g. I want to multiply fields A and B, add fields C and D, and take the minimum (so min(A*B, C+D))

#2

Try minall, e.g. [{!!A}multiply{!!B}] [{!!C}add{!!D}] +[minall[]].

Similarly, you can use the inverse, maxall, to find the largest of a set of numbers (or the numerical results of 1 or more filter runs). Any input value that cannot be parsed as a number will be treated as 0.

2 Likes