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:

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.