1.3.4.10.11 Output Selector: Sum Values
The Sum Values output selector calculates and outputs the sum of all Number values input to it from all the records being merged together.
The Sum Values selector is often used for reporting on data, where records are grouped together by a common attribute value (or attribute values), or matched together using complex rules.
For example, you might match mortgage account records that share a common household, and use the Sum Values output selector to calculate the total debt level for the household.
The following table describes the configuration options:
| Configuration | Description |
|---|---|
|
Inputs |
Any Number attributes from any input data sets. |
|
Options |
None. |
Example
In this example, the Sum Values output selector is used to select the sum of a Balance (Number) attribute from each record in a match group.
Example output
The following table shows examples of output selection using the Sum Values selector:
Table 1-110 Example Output Using Sum Values Selector
| Record A | Record B | Output value(Sum) |
|---|---|---|
|
576.34 |
-35.43 |
540.91 |
|
123.55 |
765.38 |
888.93 |
|
534.75 |
0 |
534.75 |
|
-75.15 |
-89.65 |
-164.8 |
|
65.35 |
null |
65.35 |
|
null |
null |
null |