The following aggregate functions are only available for creating input conditions and adding Attribute Transformations in the Set Selection utility. The Set Selection utility operates on groups or sets of similar records and has the following syntax:
IF(AVG(ATTRIBUTE)) > 100
OR
ATTRIBUTE1 = SUM(ATTRIBUTE2)
For more information and use case examples, see About the Set Selection Utility. For information about working with expressions, see Expression Elements.
| Function Name | Description |
|---|---|
| ALL |
Returns true if every condition is true. Example: IF(ALL(BAL > 10000)) This operation returns true if all balances in the set are greater than 10000. Note: This function can only used in an IF statement, using the following
syntax: IF(ALL(CONDITION))
|
| ANY |
Returns true if any condition is true. Example: IF (ANY(BAL > 10000)) This operation returns true if any balance in the set is greater than 10000. Note: This function can only used in an IF statement, using the following
syntax: IF(ANY(CONDITION))
|
| AVG |
Returns the average of the values for the specified attribute in each record. Example: AVG_BAL = AVG(BAL) This operation sets AVG_BAL to the mathematical average of every balance (BAL) in the set. |
| NUM |
Returns the number of records that match the condition. Example: LARGE_ACCOUNTS = NUM(BAL>10000) This operation sets LARGE_ACCOUNTS to the number of records that have a balance (BAL) greater than 10000. |
| SUM |
Returns the SUM of the values for the specified attribute in each record. Example: TOT_BAL = SUM This operation sets TOT_BAL to the mathematical SUM of every BAL in the set. |
| DEDUPE | Functions DEDUPE |