The Min function can be used to create a new column containing the smallest value out of several columns for that row.
1. For example, load the following dataset into Spotfire : ID col1 col2 col3 a 1 5 56 b 5 54 85 c 12 23 72
2. Go to Insert > Calculated Column...
3. In the Expression box enter Min([col1],[col2],[col3])
4. Select OK - a new column will be created with the values 1, 5 and 12 (the smallest values across the three columns for each row of data).