Total Aggregate Functoid
Description: The Total Aggregate Functoid will total the numeric values of all records of field X in the table connected to Field. If a Group Aggregate Functoid is used, the Total Aggregate Functoid will total the numeric values for each group.
Inputs with their allowed values:
- Field
- Output of another Functoid (numeric) (Iterated)
- Value of a Table (numeric)
_Total-aggregate.png)
Picture of the Total Aggregate Functoid
Remark: Non-numeric values are ignored.
Example: Table with group by
Group By |
Values |
Result of Total |
Group1 |
2 |
6 |
Group1 |
4 |
6 |
Group2 |
3 |
10 |
Group2 |
7 |
10 |
See Figure 1.
_Total-aggregate-example.png)
Figure 1