Using Advanced Expression Piping within your forms you can create mathematical formulas in order to calculate a value. Using the MIN function you can return the smallest value out of a list of values given by your applicants.
In this Article...
The MIN function accepts a list of floating or integer values and returns the smallest one. This can either be used for a single row or column within a grid question, the table as a whole or a list of variables within the form.
The setup and formatting of the MIN expression is imperative in preventing an error message from appearing on your form where the result of your expression would normally appear. The first line of the MIN expression should be set up as follows:
| {{ MIN(variable1,variable2) }} |
- Each expression is always contained within a pair of double "curly" brackets {{ }}
- There should be a space between the first instance of MIN and the last bracket
- Variables you are using are case sensitive
- Always close each MIN operation with brackets ( )
- Can contain a (,) to separate values. Cannot contain any operators such (+),(-),(*), etc.
| MIN of Select Cells | {{ MIN(q1[0],q1[2],[q1[3]) }} |
Based on Grid Indexing, this will give you the smallest value of the 1st, 3rd, and 4th cells. |
| MIN of a Column | {{ MIN(q1[:0]) }} |
Based on Grid Indexing, this will find the smallest value in column 1. |
| MIN of a Row | {{ MIN(q2[1:]) }} |
Based on Grid Indexing, this will find the smallest value in Row 2. |
| MIN of a Range | {{ MIN(q1[0:4]) }} |
Based on Grid Indexing, this will give you the smallest value of the first 4 cells. |
| MIN of Reviewer Scores | {{ MIN(q1.score,q2.score,q3.score) }} |
The value of the lowest score given to one of the listed questions. |
The MIN function would not be able to perform any operations using an expression such as addition (+) nor would it be possible to have other functions within a single MIN expression such as SUM to calculate the different variables together to then find the smallest value.
The best way to pull the smallest value from this information would be to have to have the SUM operations on one page and pipe the the totals to the next page using the MIN expression.