The SUBSET function has now been complemented in recent 2.6+ builds by:

- INTERSECTION - http://www.visokio.com/functions-guide#INTERSECTION
- UNION - http://www.visokio.com/functions-guide#UNION
- INVERSE - http://www.visokio.com/functions-guide#INVERSE

These greatly improve the simplicity, flexibility and power of subsets in formulas. They replace the complicated SUBSET2, SUBSET3 (etc.) functions, and more. Instead of these, use INTERSECTION(SUBSET(...), SUBSET(...), SUBSET(...)).

Examples:
The sum of Sales for all records with a different currency to the current record:
SUBSET_SUM( Sales, INVERSE(SUBSET(Currency)) )

The number of records with yield < 0.1 and in USD or GBP:
RECORDCOUNT(INTERSECTION(
UNION(SUBSET(Currency, "USD"), SUBSET(Currency, "GBP")),
SUBSET(Yield, 0.1, "<")<br />))


See Subset Functions Guide: http://www.visokio.com/kb/subset-functions