Aggregate - DoubleMaxNum

DoubleMaxNum Aggregate Functoid

Description: The DoubleMaxNum Aggregate Functoid will return the largest 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 largest numeric value of the records within each group. It has almost the same functionality as the MaxNum Aggregate Functoid but the DoubleMaxNum Aggregate Functoid has fraction support. Inputs with their allowed values:

• Field
  • Output of another Functoid (Iterated)
  • Value of a Table

Picture of the DoubleMaxNum Aggregate Functoid

 

Remark: Any non-numeric values passing through will cause an empty return value. Example: Example 1: Table with group by

Group By	Values	Result of DoubleMaxNum
Group1	2.2	4.5
Group1	4.5	4.5
Group2	3.7	7.1
Group2	7.1	7.1

See Figure 1.

Figure1