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
_DoubleMaxNum-aggregate.png)
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.
_DoubleMaxNum-aggregate-example.png)
Figure1