Aggregate - DoubleMinNum

DoubleMinNum Aggregate Functoid

Description: The DoubleMinNum Aggregate Functoid will return the lowest numeric value within the records provided to the input Field for the entire table or in case that a group functoid has been used the lowest numberic value of the records within each group. It has almost the same functionality as the MinNum Aggregate Functoid but the DoubleMinNum Aggregate Functoid has fraction support. Inputs with their allowed values:

Picture of the DoubleMinNum Aggregate Functoid

 
Remark: Any non-numeric values passing through wil cause an empty return value. Example: Example 1: Table with group by
Group By Values Result of DoubleMinNum
Group1 2.2 2.2
Group1 4.5 2.2
Group2 3.7 3.7
Group2 7.1 3.7
See Figure 1.

Figure 1